摘要:
批量插入测试数据use Testdeclare @count INTset @count = 0while(@count < 10)begin waitfor delay '000:00:10'insert into Northwind(CategoryName,[Description])values('Beverages', 'test')set @count=@count+1end数据库分页-用到ROW_NUMBE()select * from (select *, ROW_NUMBER() over (order by Id) as 阅读全文