卢海兵的专栏

 while 1=1begin waitfor delay 00:05:00 exec Pinsertend

 IF OBJECT_ID(tb) IS NOT NULLDROP TABLE tbGOCREATE TABLE tb( a varchar(30))goinsert tb SELECT 001,003,008 UNION ALL SELECT 003,008,019godeclare @s varchar(40)select @s=isnull(@

DECLARE @fieldtype sysname SET @fieldtype=varchar --删除处理 DECLARE hCForEach CURSOR GLOBAL FOR SELECT Nupdate +QUOTENAME(o.name) +N set + QUOTENAME(c.name) + N = replace( + QU

CREATE TABLE tb( ID INT IDENTITY NOT NULL, StartDateTime DATETIME, CONSTRAINT CHK_CONS_STARTDATETIME CHECK(StartDateTime < GETDATE()));

 declare @tablea table (id int,[type] int,number int,area int,[power] int)insert into @tableaselect 1,1,23,78,98 union allselect 2,2,56,27,67 union allselect 3,3,21,34,23 union allselect 4,4

 declare @prod table (pid int, title varchar(30))insert into @prodselect 1,测试产品1 union allselect 2,测试产品2 union allselect 3,测试产品3 union allselect 4,测试产品4 union allselect 5,

select   convert(char(10),getdate(),120)