declare @i int
set @i=0
while @i<100
begin
print '123'
set @i=@i+1
set @i=0
while @i<100
begin
print '123'
set @i=@i+1
end
行数查询
select Guid,MaterialGuid,StockGuid,Amount,0 from (select row_number() over(partition by MaterialGuid,StockGuid order by MakeDate,SignDate,Guid) as rownum,Guid,MaterialGuid,StockGuid,Amount from #T where FStatus=0 )T where rownum=1