摘要:
declare @d datetimeset @d = getdate()select top 10 U_Name from Test1 where ID not in (select top 30 ID from Test1 order by ID desc) order by ID descselect [语句执行花费时间(毫秒)]=datediff(ms,@d,getdate()) go 阅读全文
摘要:
declare @i intset @i = 1while @i<100000beginexec Proc_InsertTest1 '测试使用数据',20,'男','地球村'set @i = @i+1end 阅读全文