摘要：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... 阅读全文

摘要：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 ... 阅读全文