三 SQL杂七杂八

批量插入测试数据

use Test
declare @count INT
set @count = 0
while(@count < 10)
begin
waitfor delay '000:00:10'
insert into Northwind(CategoryName,[Description])
 values('Beverages', 'test')
set @count=@count+1
end

 

数据库分页-用到ROW_NUMBE()

select * from (
select *, ROW_NUMBER() over (order by Id) as rank from dbo.tablename
) as t where t.rank between 1 and 10

转载于:https://www.cnblogs.com/lilideng/p/SQLZ7Z8.html

总结

以上是生活随笔为你收集整理的三 SQL杂七杂八的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。