begin tran
declare @num int
set @num =0
while @num<500000
begin
update wcode set password =‘a‘ + CAST (@num as nvarchar(50)) where wcode =‘9998‘
set @num =@num +1
end
commit tran
另外一个查询
select wcode ,password from wcode where wcode =‘9998‘
原文：http://www.cnblogs.com/szyicol/p/5037897.html