22,209
社区成员
发帖
与我相关
我的任务
分享
exec('select top '+ @count + ' number,password,validity,zengpin from visualCard
where pid = '+ @productID +' order by importTime')
select identity(int,1,1) as id,number,password,validity,zengpin
into #temp from visualCard
where pid = @productID order by importTime
select number,password,validity,zengpin
from #temp where id<=@count