ÔÚÖ¸¶¨µÄλÖò»´æÔÚÓÐЧµÄSQLServer°²×°
°²×°SQLServer2000¸öÈ˰棬µ½¡°°²×°ÀàÐÍ¡±½çÃæ£¬²»¹ÜÑ¡ÔñʲôѡÏ²»¹ÜÓÃĬÈÏ·¾¶»¹ÊÇ×Ô¶¨Òå·¾¶£¬µã»÷ÏÂÒ»²½£¬¶¼µ¯³ö¡°ÔÚÖ¸¶¨µÄλÖò»´æÔÚÓÐЧµÄSQLServer°²×°—C:\Program Files\Microsoft SQL Server¡±µÄ¶Ô»°¿ò£¬ÇëÎÊÕâÊÇΪºÎ£¿
Õâ¸ö°²×°³ÌÐòÎÒ¹ýÈ¥Ò»Ö±ÔÚÓ㬶¼ÓÃÁËÎå¡¢Áù´ÎÁË£¬¹ýȥһֱû³öÏÖ¹ýÕâÖÖÎÊÌâ¡£
ÎÒ²»ÊÇ˵ÁËÂð£¬ÎÒ²»¹Ü»»Ê²Ã´Â·¾¶£¬¶¼ÌáʾÕâ¸ö´í¡£
ÓпÉÄÜÄãµÄ²Ù×÷ϵͳÓÐÎÊÌ⣬±È½ÏÊܵ½²¡¶¾¹¥»÷µÈ¡£
¹À¼Æ»¹ÊÇÂ¥Ö÷µÄ×¢²á±í³öÎÊÌâÁË ÏÈÕÒ¸öÇåÀí¹¤¾ßÇåÀíÏ ȻºóÔÙÊÔ ÎÒ¾õµÃÓпÉÄÜÊÇÄãµÄϵͳ³öÁËÒ»µãÎÊÌâ
ÎÒ½ñÌì9µãÔ糿¸Õ¸ÕÖØ×°ÏµÍ³£¬10µã¸Õ´òÍê112¸ö©¶´²¹¶¡£¬²¢×°ÉÏÁËÕý°æÉ±¶¾Èí¼þ¡£
ÎÒÔÚ°²×°¹ý³ÌÖÐÑ¡ÔñÁË¡°Öؽ¨×¢²á±í¡±Ñ¡Ï²»ÖªµÀÊDz»ÊÇÕâ¸öÎÊÌâ¡£
ÖØÆôһϾÓÈ»ºÃÁË
Ïà¹ØÎÊ´ð£º
ÔÚSqlServerÖÐÈçºÎ²é¿´ÀúÊ·ÉÏÖ´ÐеĴ洢¹ý³ÌµÄÐÅÏ¢ÄØ£¬È磺´«Èë²ÎÊý£¬Ö´ÐÐʱ¼äµÈµÈ¡£Èç¹û²»Äܲ鿴ÀúÊ·¼Ç¼£¬ÊÇ·ñ¿ÉÒÔ×Ô¼ºÐ´´¥·¢Æ÷Ö®ÀàµÄ£¬È˹¤¿ØÖÆÄØ£¬ÔÚOracleÀïÃæÓж¯Ì¬ÊÓͼ¿ÉÒÔËæÊ±²é¿´ÀúÊ·Ö´ÐеÄsqlÓï¾ä£¬SqlSer ......
ÏÈÓÉÈçÏÂsqlÓï¾ä
select A,B,C from table1
union
select A,B,C from table2
order by A, C asc
µÃµ½½á¹ûÈçÏ£º
A B &nbs ......
ֻΪ¶úå¦Ä¿È¾£¬ÓÐËù½ø²½£¡
ßµ°Ý£¡
..
ÕâÀï¾ÍÊÇ
ÕâÀï±ÈQQȺÀïÈÈÄÖ
ÎÒÒ²ÏëÕÒÕâô¸öȺ
.
SQL code:
¡£¡£¡£¡£¡£
¡£
ºÇºÇ
ÒýÓÃ
ÕâÀï±ÈQQȺÀïÈÈÄÖ
ͬÒâ
發錯° ......
sqlserver,Èç¹û¼Ó¸öÓû§,ȨÏÞÊǶÁËùÓÐ±í£¬µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ
ûÕâ¸ö˵·¨.
Ö»¸øSELECT ,
UPDATEµÄÖ»¸øÄ³Ð©±í
¸ö²»»á
µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ Õâ¸öÄѸã
Òª¼ÓȨÏÞµÃÕë¶Ôij¸öÊý¾Ý¿â
......
xp(sp3)ϵͳ°²×°ÁËsqlserver2000£¬sp3£¬sp4²¹¶¡¶¼´òÁË¡£¶øÇÒ±¾»úÒ²ÄÜÁ¬½Ó·ÃÎÊ¡£
ÎÊÌâÊÇ£º
±¾»útelnet ip 1433 ×ÜÊÇÌáʾÁ¬½Óʧ°Ü£¬
¶øÇÒnetstat -naʱ£¬¿´²»µ½1433¶Ë¿Ú±»Õ¼ÓÃ
(¿Ï¶¨µÄÊÇ£º¶Ë¿ÚÊÇ1433£¬¿ªÆ ......