07 2010 档案

UPDATE FROM
摘要：DECLARE @TEMP1 TABLE(ID INT,Name NVARCHAR(30),Ex INT)DECLARE @TEMP2 TABLE(ID INT,Name NVARCHAR(30),Ex INT)INSERT INTO @TEMP1(ID,Name,Ex)SELECT 1,'1',0 UNION ALLSELECT 2,'2',0 UNION ALLSELECT 3,'3',0 U... 阅读全文
posted @ 2010-07-13 11:39 kkun 阅读(334) 评论(0) 推荐(0) 编辑
PIVOT方法演练
摘要：DECLARE @TEMP TABLE(ID CHAR(1),ODATE VARCHAR(8),OPERCENT FLOAT)INSERT INTO @TEMP(ID,ODATE,OPERCENT)SELECT 'A','20100701',0.71 UNION ALLSELECT 'B','20100701',69.42 UNION ALLSELECT 'C','20100701',67.74 ... 阅读全文
posted @ 2010-07-07 13:17 kkun 阅读(247) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示