摘要: 批量插入测试数据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 阅读全文
posted @ 2013-10-12 14:16 Lilideng 阅读(133) 评论(0) 推荐(0) 编辑