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

SQL Server2005ÖеÄSQL ServerÉí·ÝÑéÖ¤µÄÉèÖÃ


¸Õ¸Õ×°ÁËSQL2008£¬ÅäÖÃÁËһϣ¬ÔÚÍøÉÏÕÒµ½Õâ¸ö½Ì³Ì£¬¾õµÃ²»´í£¬×ªÔØÑ§Ï°
1¡¢ ¸ü¸ÄTCP/IPÁ¬½ÓΪÆôÓÃ
2¡¢ µÇ¼ £¬ ÐÞ¸Ä2¸öµØ·½
    a) Éí·ÝÑéÖ¤·½Ê½£¨»ìºÏģʽ£©
        ͼһ£ºÊ×ÏÈʹÓÃwindowsÉí·ÝµÇ¼£¨×¢Ò⣬ ·þÎñÆ÷Ãû³Æ±ØÐëÌîдÕýÈ·£©
        ͼ¶þ£º´ò¿ªSQL ʵÀýµÄÊôÐÔ
        ͼÈý£ºÑ¡Ôñ×ó±ßµÄ“°²È«ÐÔ”£¬ ×¢Òâ×öÈçÏÂÑ¡Ôñ
    b) ÆôÓÃsa£¬ Èô½«saµÄÃÜÂëÉèÖÃΪ¿ÕÃÜÂ룬 Ìø¹ýµÚÒ»²½£» ÈôÃÜÂ벻Ϊ¿Õ£¬ Á½²½Í¬Ê±ÉèÖ㬠¼´£º2¸ö¶¼ÉèÖÃÍê³Éºóµã»÷È·¶¨¼´¿É¡£
        i. µÚÒ»²½£¬ ÆôÓÃSa
        ¸ü¸ÄÍê³Éºó£¬µ¥»÷È·¶¨±£´æ
        ii. µÚ¶þ²½£¬ÉèÖÃÃÜÂë
¸ü¸ÄÍê³Éºó£¬µ¥»÷È·¶¨±£´æ
µ±È»Õû¸öÉèÖÃÍê³ÉÖ®ºó£¬ »¹ÐèÒªÖØÆôsql·þÎñ£¬Èç¹û»¹²»ÐУ¬ÔÙÈ¥¿ØÖÆÃæ°å£¬¹ÜÀí¹¤¾ß£¬·þÎñÖÐÕÒµ½SQL Server (MSSQLSERVER)ÏÈÍ£Ö¹£¬ÔÙÆô¶¯£¬È»ºóÔÙÖØÐÂÆô¶¯SQL£¬Ó¦¸ÃûÎÊÌâÁË£¡


Ïà¹ØÎĵµ£º

SQL Server 2005ÖеÄT SQLÔöÇ¿(3) TOP OUTPUT

TOP ÔöÇ¿¹¦ÄÜ
1¡¢TOP ÔöÇ¿¡£¿ÉÒÔÖ¸¶¨Ò»¸öÊý×Ö±í´ïʽ£¬ÒÔ·µ»ØÒªÍ¨¹ý²éѯӰÏìµÄÐÐÊý»ò°Ù·Ö±È£¬»¹¿ÉÒÔ¸ù¾ÝÇé¿öʹÓñäÁ¿»ò×Ó²éѯ¡£
¿ÉÒÔÔÚDELETE¡¢UPDATEºÍINSERT²éѯÖÐʹÓÃTOPÑ¡Ïî¡£
2¡¢¸üºÃµØÌæ»»SET ROWCOUNTÑ¡Ïʹ֮¸üΪÓÐЧ¡£
OUTPUT
1¡¢SQL Server 2005ÒýÈëÒ»¸öеÄOUTPUT×Ӿ䣬ÒÔʹÄú¿ÉÒÔ³åÐÞ¸ÄÓï¾ä(INSERT¡ ......

Ô¶³ÌÁ¬½ÓSQL Server2000·þÎñÆ÷µÄ½â¾ö°ì·¨

µ±ÎÒÃÇÀûÓÃSQL Server×÷Ϊºǫ́Êý¾Ý¿â½¨ÍøÕ¾µÄʱºò£¬»áÉæ¼°µ½Ô¶³ÌÁ¬½ÓSQL Server·þÎñÆ÷µÄÎÊÌ⣬µ«ÊǾ­³£»á³öÏÖÁ¬½Óʧ°ÜµÄÏÖÏó£¬ÏÖÔڰѽâ¾ö°ì·¨¹éÄÉһϣ¬ÒÔ×÷×ܽᡣ
Ò» ¿´ping ·þÎñÆ÷IPÄÜ·ñpingͨ¡£
    Õâ¸öʵ¼ÊÉÏÊÇ¿´ºÍÔ¶³Ìsql server 2000·þÎñÆ÷µÄÎïÀíÁ¬½ÓÊÇ·ñ´æÔÚ¡£Èç¹û²»ÐУ¬Çë¼ì²éÍøÂ磬²é¿´ÅäÖ㬵± ......

ÔÚOracle 9iÖÐÐ޸ıíµÄ½á¹¹µÄÏà¹ØsqlÓï¾ä

ÓÃsql*plus»òµÚÈý·½¿ÉÒÔÔËÐÐsqlÓï¾äµÄ³ÌÐòµÇ¼Êý¾Ý¿â£º
Ôö¼ÓÒ»¸öÁУº
ALTER TABLE ±íÃû ADD(ÁÐÃû Êý¾ÝÀàÐÍ);
È磺
ALTER TABLE emp ADD(weight NUMBER(38,0));
ÐÞ¸ÄÒ»¸öÁеÄÊý¾ÝÀàÐÍ(Ò»°ãÏÞÓÚÐ޸ij¤¶È£¬ÐÞ¸ÄΪһ¸ö²»Í¬ÀàÐÍʱÓÐÖî¶àÏÞÖÆ):
ALTER TABLE ±íÃû MODIFY(ÁÐÃû Êý¾ÝÀàÐÍ);
È磺
ALTER TABLE emp MODIFY(wei ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ