thesum的专栏

select SourceUserID,SourceGold,SourceBank,SwapScore,ClientIP,CollectDate from master.dbo.RecordInsure a1 where exists (select  1 from master.dbo.RecordInsure a2 where a2.SourceUserID=a1.SourceUserID h

declare @i intset @i = 1while @i begin    update top (1) @t set name = @i where name = '123'    set @i = @i + 1end

delete from stock.dbo.hq  where PriceNow is NULL