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

SQL Server 2005Ö§³ÖµÄÁ½ÌõÐÂÓï·¨

±¾ÎĽéÉÜÁËSQL Server 2005ÖÐÉÙÊýÈËÓõ½µÄÁ½Ìõ¾«Æ·ÐÂÓï·¨£¬´ó¼Ò¿´¿´×Ô¼ºÊÇ·ñÖªµÀÄØ……
¡¡¡¡1. OUTPUT ... INTO
¡¡¡¡ÓÃÓÚ½«Ò»Ìõ¼Ç¼´Ó±íÒ»ÒÆ¶¯µ½±í¶þʱ·Ç³£ºÃÓ㬳£¼ûÓÚ±¸·Ý¼Ç¼µÄÓ¦ÓÃ
¡¡¡¡ÀýÒ»£º
¡¡¡¡DELETE [TableUseing]
¡¡¡¡OUTPUT *
¡¡¡¡INTO [TableBak]
¡¡¡¡Àý¶þ£º(ÓÃÓÚÒÆ¶¯Ê±ÐÞ¸Äij×ֶεÄÖµ)
¡¡¡¡DELETE [TableUseing]
¡¡¡¡OUTPUT Field1, Field2, GETDATE()
¡¡¡¡INTO [TableBak]
¡¡¡¡2.±í±äÁ¿
¡¡¡¡ÓÃÓÚ´æ´¢ÁÙʱµÄ²éѯ½á¹û
¡¡¡¡DECLARE @tmp TABLE (ID INT, CITY NVARCHAR(50))
¡¡¡¡INSERT INTO @tmp
¡¡¡¡SELECT MIN(ID), CITY
¡¡¡¡from [TableTest] WITH(NOCLOCK)
¡¡¡¡GROUP BY CITY


Ïà¹ØÎĵµ£º

ʹÓù«Óñí±í´ïʽ£¨CTE£©¼ò»¯Ç¶Ì×SQL ºÍ½øÐеݹéµ÷ÓÃ

1.ʹÓÃCTE¼ò»¯Ç¶Ì×sql
   ÏÈ¿´ÏÂÃæÒ»¸öǶÌ׵IJéѯÓï¾ä£º
select * from person.StateProvince where CountryRegionCode in 
         (select CountryRegionCode from person.CountryRegion where  ......

case when then...else end sql Óï¾äÓ÷¨

select f.AGENTID as 'ID',
          f.AGENTNAME as 'ÐÕÃû',
          f.COMNAME as '¹«Ë¾¼ò³Æ',
          c.REGISTDATE as '×¢²áʱ¼ä',
     ......

SQL ServerÖÐpivot and unpivotµÄÓ÷¨ £¨ÐÐÁл¥×ª£©

 .PivotµÄÓ÷¨Ìå»á:
Óï¾ä·¶Àý:
select PN,[2006/5/30] as [20060530],[2006/6/2] as [20060602]
from consumptiondata a
Pivot (sum(a.M_qty) FOR a.M_date in ([2006/5/30],[2006/6/2])) as PVT 
order by PN
 
Table½á¹¹ Consumptiondata (PN,M_Date,M_qty)
order by PN¿ÉÒª¿É²»Òª,²¢²»ÖØ ......

SQL SERVER ÓëACCESS¡¢EXCELµÄÊý¾Ýת»»

 ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXC ......

¹ØÓÚдSQLÓï¾ä

Çë½Ì¸ßÊÖÒ»¸öÎÊÌ⣬ÎÊÌâÃèÊöÈçÏ£º
A±íÊǸ÷¸öµ¥Î»µÄÃû³Æ±í ×Ö¶ÎΪ org_id ºÍ org_name
B±íÊÇÕâЩµ¥Î»µÄµç»°ºÅÂë±í ×Ö¶ÎΪ org_idºÍ tel
A±í B±í¹ØÁª·½Ê½ÎªA.ORG_ID=B.ORG_ID 
org_idÊǸ÷¸öµ¥Î»µÄ´úÂë
org_nameÊǸ÷¸öµ¥Î»µÄÃû³Æ
telÊǸ÷¸öµ¥Î»µÄµç»°ºÅÂë
±¾ÈËÏÖÔÚÏëÕë¶Ôÿ¸öµ¥Î»£¨Ã¿Ìõorg_id£©È¡Æä10¸öºÅÂë
Ç ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ