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
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
