摘要：
declare @a int set @a=0 while @a<10 begin declare @time datetimeset @time=getdate()select count(*) from test left join t1 on t1.id = test.idinsert into time values (datediff(ms,@time,getdate()))... 阅读全文
摘要：
create PROCEDURE [dbo].[pagelist1]/****************************************************************** 千万数量级分页存储过程 *****************************************************************参数说明:1.Tables :表名称,视图... 阅读全文
摘要：
--填充表create proc [dbo].[filltable] (@rows int)as DECLARE @INT AS INT SET @INT = 0 WHILE @INT < @rows --这里设置需要插入多少行 BEGIN SET @INT = @INT + 1 INSERT INTO test (name) SELECT substring(cast(newid() as... 阅读全文
摘要：
create table t1(id int, feild int);insert into t1 values(1 , 1);insert into t1 values(1 , 2);insert into t1 values(1 , 3);insert into t1 values(1 , 4);insert into t1 values(2 , 1);insert into t1 value... 阅读全文