Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÔÚCMDϲÙ×÷SQL SERVERÊý¾Ý¿â


MYSQL¿ÉÒÔÔÚ¿ØÖÆÌ¨Ï½øÐвÙ×÷£¬ÀûÓÃÃüÁî
SQL´úÂë
mysql -h localhost -u root -p123456  
¾Í¿ÉÒԵǽMYSQLµÄ¿ØÖÆÌ¨¡£
sql serverÒ²ÌṩÁË¿ØÖÆÌ¨ÏµIJÙ×÷¹¦ÄÜ¡£
ÔÚSQL SERVERµÄ binnĿ¼Ï£¬ÌṩÁËosql.exeÓëisql.exeÕâÁ½¸öÎļþ¡£
ÕâÁ½¸ö³ÌÐò¶¼ÌṩÁË·ÃÎÊSQL SERVERµÄ¹¦ÄÜ£¬ÕâÁ½¸ö³ÌÐòÔÚÁ¬½ÓSQL SERVERµÄ·½Ê½ÉÏÓÐÇø±ð¡£
osql.exeͨ¹ýODBCµÄ·½Ê½ÓëSQL SERVER½øÐÐÁ¬½Ó £¬¶øisql.exeͨ¹ýdb libraryµÄ·½Ê½À´Á¬½ÓSQL SERVER¡£
CSDNÉϵÄÊý¾Ý¿âÅ£ÃÇÍÆ¼öʹÓÃOSQL½øÐвÙ×÷£¬¾ßÌåÔ­ÒòÒ²²»¹ÜÄÇô¶àÁË£¬ÔÛÃÇ»áµã¼òµ¥µÄ²Ù×÷¾ÍÐÐÁË¡£¡£
ÔÚCMDÏÂÊäÈëosql -? ¾Í¿ÉÒÔ¿´µ½°ïæÐÅÏ¢ÁË¡£
C:\>osql -?
Microsoft (R) SQL Server ÃüÁîÐй¤¾ß
°æ±¾ 9.00.1399.06 NT INTEL X86
°æÈ¨ËùÓÐ (c) Microsoft Corporation¡£±£ÁôËùÓÐȨÀû¡£
×¢Òâ: osql ²¢²»Ö§³Ö SQL Server 2005µÄËùÓй¦ÄÜ¡£
ÇëʹÓà sqlcmd¡£ÓйØÏêϸÐÅÏ¢£¬Çë²ÎÔÄ SQL Server Áª»ú´ÔÊé¡£
Ó÷¨: osql                   [-U µÇ¼ ID]          [-P ÃÜÂë]
  [-S ·þÎñÆ÷]                [-H Ö÷»úÃû]           [-E ¿ÉÐÅÁ¬½Ó]
  [-d ʹÓÃÊý¾Ý¿âÃû³Æ]        [-l µÇ¼³¬Ê±Öµ]       [-t ²éѯ³¬Ê±Öµ]
  [-h ±êÌâ]                  [-s Áзָô·û]         [-w Áпí]
  [-a Êý¾Ý°ü´óС]            [-e »ØÏÔÊäÈë]         [-I ÔÊÐí´øÒýºÅµÄ±êʶ·û]
  [-L Áгö·þÎñÆ÷]            [-c ÃüÁî½áÊø]         [-D ODBC DSN Ãû³Æ]
  [-q "ÃüÁîÐвéѯ"]          [-Q "ÃüÁîÐвéѯ" ²¢Í˳ö]
 


Ïà¹ØÎĵµ£º

java¡¢C#ÖÐSqlÓï¾ä´«²ÎµÄд·¨¼°ÒâÒå

 SqlserverÕâ¶«Î÷ûÉÙ¸úËû´ò½»µÀ,¸Õѧ¿ª·¢ÓïÑÔʱ¾ÍÒѾ­¸úËû½Ó´¥ÁË,²»ÒªËµºÜ¾«Í¨,µ«¾ÍÓï·¨»¹ËãÊÇÊìϤ,µ«ÏÖÔÚ¿ªÊ¼Ð´C#,·¢ÏÖºÜC#¶àÁËÒ»ÖÖSqlServerµÄ²ÎÊý´«È뷽ʽ,ÒÔÍùÎÒÃdz£³£¶ÔÒª´«²ÎµÄSqlÓï¾ä¶¼ÊÇÖ±½Óͨ¹ýÆ´´ÕSqlÓï¾äµÄ·½Ê½À´ÊµÏÖ,µ«ÏÖÔÚC#ΪʲôҪרÃÅ×öÒ»¸öSql²ÎÊýµÄÀàÀ´ÊµÏÖÄØ,¾­¹ý²éÕÒ²ÅÖªµÀ,ÕâÑù×öÊÇÓеÀÀíµÄ,Ò»Ê ......

SQL SERVERµÄÊý¾ÝÀàÐÍÁíÒ»°æ×ܽá

1.SQL SERVERµÄÊý¾ÝÀàÐÍ
¡¡¡¡Êý¾ÝÀàŪÊÇÊý¾ÝµÄÒ»ÖÖÊôÐÔ£¬±íʾÊý¾ÝËù±íʾÐÅÏ¢µÄÀàÐÍ¡£ÈκÎÒ»ÖÖ¼ÆËã»úÓïÑÔ¶¼¶¨ÒåÁË×Ô¼ºµÄÊý¾ÝÀàÐÍ¡£µ±È»£¬²»Í¬µÄ³ÌÐòÓïÑÔ¶¼¾ßÓв»Í¬µÄÌØµã£¬Ëù¶¨ÒåµÄÊý¾ÝÀàÐ͵ĸ÷ÀàºÍÃû³Æ¶¼»ò¶à»òÉÙÓÐЩ²»Í¬¡£SQLServer ÌṩÁË 25 ÖÖÊý¾ÝÀàÐÍ£º
¡¡¡¡·Binary [(n)]
¡¡¡¡·Varbinary [(n)]
¡¡ ......

ÔÚVB2008 ËٳɰæÖÐʹÓòÎÊý»¯SQL²éѯÓï¾äÎÞЧ

  ×î½ü¸Õѧ»áÔÚVB2008 ÖÐʹÓòÎÊý»¯SQLÓï¾ä£¬ÓÚÊÇÂíÉÏÓõ½´úÂëÖУ¬È´Åöµ½²é²»µ½ÈκÎÊý¾ÝµÄÇé¿ö£¬¾À½áÁ˺ü¸Ì죬»¹ÊÇûÓиãÃ÷°×£¬²îµãÍÂѪ¡£²»µÃÒÑ»¹ÊÇÏÈÔÚ´úÂëÖÐʹÓÃ×Ö·û´®Æ´½ÓµÄSQLÓï¾ä¡£
  °üº¬²ÎÊý»¯SQLÓï¾äµÄ´úÂëÈçÏ£º
            Dim cmSl As N ......

VCʹÓÃSQLDMO²Ù×÷SQL Server

BOOL StartServer()
{
    if(FAILED(CoInitialize(NULL)))
    {
        AfxMessageBox(_T("Com³õʼ»¯Ê§°Ü"));
        return FALSE;
    }
    _SQLServerPtr spSQLServer ......

sql server Ë÷Òý

sql server ´´½¨Ë÷Òý
http://54laobaixing.blog.163.com/blog/static/57843681200952411133121/
SQL SERVERË÷Òý,ÓÅ»¯
http://tieba.baidu.com/f?kz=170889655
Sybase SQL ServerË÷ÒýµÄʹÓúÍÓÅ»¯
http://www.yesky.com/79/211079.shtml ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ