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

sql server 2005´¥·¢Æ÷ѧϰ±Ê¼Ç£¨Ò»£©

        ´¥·¢Æ÷ʵ¼ÊÉϾÍÊÇÒ»ÖÖÌØÊâÀàÐ͵Ĵ洢¹ý³Ì£¬ÆäÌØÊâÐÔ±íÏÖÔÚ£ºËüÊÇÔÚÖ´ÐÐÌØ¶¨µÄT-SQL ×Ô¶¯Ïà¼ÓµÄ¡£
   
        ´¥·¢Æ÷·ÖΪÁ½Àࣺ 
                               Ò»£º DML ´¥·¢Æ÷
                                                   DML´¥·¢Æ÷Êǵ±Êý¾Ý¿â·þÎñÆ÷Öз¢ÉúÊý¾Ý²Ù×÷ÓïÑÔʼþÖ´ÐеĴ洢¹ý³Ì¡£
                                                    DML·ÖΪ£º AFTER ´¥·¢Æ÷ ºÍ  Instead Of´¥·¢Æ÷
                               ¶þ£º DLL´¥·¢Æ÷
                                                     DDL´¥·¢Æ÷ÊÇÔÚÏìÓ¦Êý¾Ý¶¨ÒåÓïÑÔʱ¼äʱִÐеĴ洢¹ý³Ì¡£DDL´¥·¢Æ÷Ò»°ãÓÃÓÚÖ´ÐÐÊý¾Ý¿âÖйÜÀíÈÎÎñ¡£ÈçÉóºËºÍ¹æ·¶Êý¾Ý¿â²Ù×÷¡¢·ÀÖ¹Êý¾Ý±í½á¹¹±»Ð޸ĵȡ£
        
        ´¥·¢Æ÷×÷Óãº
                &n


Ïà¹ØÎĵµ£º

sql ²éѯ

ÓÐÒÔ϶þÕÅ±í£º
Õþµ³±í£ºÕþµ³ID£¬Õþµ³Ãû³Æ
ÒéÔ±±í£ºÒéÔ±ID£¬ÒéÔ±Ãû³Æ£¬Õþµ³ID
ÒªÇó²éѯËùÓеÄÕþµ³ÐÅÏ¢£¬°üº¬£ºÕþµ³Ãû³Æ£¬ÒéÔ±ÈËÊý£¬²¢°´ÒéÔ±ÈËÊýµÄ½µÐòÅÅÁУ¨²»¿ÉÒÔÓÃ×Ó²éѯ£©¡£
Õý½â:
SELECT a.name,
  COUNT(b.id) AS counts
  from zhen a
left join
  yi b
on a.id=b.zhenid
GROUP ......

ÈçºÎд¸ßЧµÄÅúÁ¿²åÈëºÍɾ³ýsqlÓï¾ä

×÷Õߣº²»Ïê ³ö´¦£ºÍøÂç×ªÔØ  2009/11/18 10:35:22 ÔĶÁ 109  ´Î
¡¡¡¡¼¼Êõˮƽ×ÜÄÜÔÚ³¶Æ¤ºÍ´µÃ«Çó´ÃÖеõ½Ìá¸ß¡£Èç¹û´ÓÀ´²»“Çó´Ã”£¬¿ÉÄܾͲ»»áÖªµÀif(str != "")²»Èçif(str != string.Empty)¸ßЧ¡¢ÅúÁ¿²åÈëºÍɾ³ýµÄsqlÓï¾äÊÇÒªÄÇÑùд²ÅÖ´ÐÐ×î¿ì¡¢½Ó¿ÚºÍ³éÏóÀàµÄÇø±ð²»½öÊÇÓïÑÔ²ãÃæ¡¢ ......

½â¾öSQL Server°²×°¹ÒÆð

¹À¼ÆÄãÊǰ²×°Ê±³öÏÖµÄÎÊÌâ¡£
½â¾ö·½·¨...
¹ØÓÚSQL°²×°±»¹ÒÆðµÄÐÞ¸´´ó¼Ò¿ÉÄܶ¼Óöµ½¹ýµ±SQL±»É¾³ýºóÐèÒªÖØÐ°²×°Ê±£¬½øÈë°²×°½çÃæ¾Í»á³öÏÖSQL´íÎóÌáʾ£º
´ÓǰµÄ°²×°³ÌÐò²Ù×÷ʹ°²×°³ÌÐò²Ù×÷¹ÒÆð£¬ÐèÒªÖØÐÂÆô¶¯¼ÆËã»ú
È»¶øÕâЩ¶¼Êǰ׷Ѿ¢£¬²»¹ÜÄãÖØÐÂÆô¶¯¶àÉÙ´ÎÒ²¶¼ÎÞ¼ÃÓÚÊ£¬ÏÂÃæÎҾͽ²½²ÔõÑùÄܹ»½â³ý°²×°»òÉý¼¶Ê±Îļþ±»¹Ò ......

²é¿´SQL Server2005°æ±¾¼°²¹¶¡°æ±¾ÐÅÏ¢

SQL Server2005°æ±¾ºÅ£º
Ҫȷ¶¨ËùÔËÐÐµÄ SQL Server 2005 µÄ°æ±¾£¬ÇëʹÓà SQL Server Management Studio Á¬½Óµ½ SQL Server 2005£¬È»ºóÔËÐÐÒÔÏ Transact-SQL Óï¾ä£º(´ËSQLÓï¾äͬÑùÊÊÓÃÓÚSQL2000)
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
²éѯ½á¹ûÈçÏ£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ