ÔÚ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 "ÃüÁîÐвéѯ" ²¢Í˳ö]
Ïà¹ØÎĵµ£º
дһ¸ö´æ´¢¹ý³Ì£¬½«±íÒ»°´ÕÕ±í¶þµÄÐÎʽ½øÐвéѯ¡£
²Ö¿âÃû³Æ ÉÌÆ·Ãû³Æ ÊýÁ¿
A
S001 12
A S002 17
A
S003 10
B S001 21
B
S002 5
B S003 ......
¼ÇµÃÒÔǰÓÃSqlServer 2000µÄʱºòÔÚ“ÓÒ¼üÊý¾Ý¿â->ËùÓÐÈÎÎñ->µ¼ÈëÊý¾Ý/µ¼³öÊý¾Ý”Õâ¸öÑ¡Ïµ«ÊÇ×î½üÔÚʹÓÃSqlServer 2005 expressµÄʱºò·¢ÏÖ¾ÓȻûÓГµ¼Èë/µ¼³ö”¹¦ÄÜ£¬Õâ¸öÈÃÈËÏ൱ÓôÃÆ¡£
ºóÀ´ÍøÉÏÒ»²é²ÅÖªµÀÊÇÒòΪÎÒÓõÄÊÇex ......
SQL:1999Á¬½Ó
SQL:1999Á¬½ÓÔÚÓï·¨ÉϺʹ«Í³µÄORACLEÁ¬½ÓÓÐןܴóµÄ²»Í¬¡£SQL:1999Á¬½ÓµÄÀàÐÍÔÚfromÓï¾äÖÐÖ¸Ã÷¡£ORACLE 9IÖ§³ÖµÄSQL:1999Á¬½Ó°üÀ¨£º
l CROSSÁ¬½Ó
l NATURALÁ¬½Ó
l ......
SqlserverÕâ¶«Î÷ûÉÙ¸úËû´ò½»µÀ,¸Õѧ¿ª·¢ÓïÑÔʱ¾ÍÒѾ¸úËû½Ó´¥ÁË,²»ÒªËµºÜ¾«Í¨,µ«¾ÍÓï·¨»¹ËãÊÇÊìϤ,µ«ÏÖÔÚ¿ªÊ¼Ð´C#,·¢ÏÖºÜC#¶àÁËÒ»ÖÖSqlServerµÄ²ÎÊý´«È뷽ʽ,ÒÔÍùÎÒÃdz£³£¶ÔÒª´«²ÎµÄSqlÓï¾ä¶¼ÊÇÖ±½Óͨ¹ýÆ´´ÕSqlÓï¾äµÄ·½Ê½À´ÊµÏÖ,µ«ÏÖÔÚC#ΪʲôҪרÃÅ×öÒ»¸öSql²ÎÊýµÄÀàÀ´ÊµÏÖÄØ,¾¹ý²éÕÒ²ÅÖªµÀ,ÕâÑù×öÊÇÓеÀÀíµÄ,Ò»Ê ......
--
SQL Server Splitº¯Êý
--
Author:zc_0101
--
˵Ã÷£º
--
Ö§³Ö·Ö¸î·û¶à×Ö½Ú
--
ʹÓ÷½·¨
--
Select * from DBO.F_SQLSERVER_SPLIT('1203401230105045','0')
--
select * from DBO.F_SQLSERVER_SPLIT('abc1234a12348991234',' ......