declare @page table(id int PRIMARY KEY)
insert into @page select top 10000 id from [article] order by addtime desc
select count(*) from @page
article表有16万条数据,可是一次插入到@page中只有5000条数据
...全文
34014打赏收藏
表变量最多只能插入5000行数据?
declare @page table(id int PRIMARY KEY) insert into @page select top 10000 id from [article] order by addtime desc select count(*) from @page article表有16万条数据,可是一次插入到@page中只有5000条数据