简单的游标实列

Declare @duifname varchar(20)
declare @duifbsh varchar(20)
Declare tbl_cur cursor for 
select duifname,duifbsh from lsdtxb

OPEN tbl_cur

FETCH NEXT  from tbl_cur INTO @duifname,@duifbsh

WHILE @@FETCH_STATUS = 0
BEGIN

update lsss set a=rtrim(a)+@duifname+@duifbsh

FETCH NEXT  from tbl_cur INTO @duifname,@duifbsh
END

CLOSE tbl_cur
DEALLOCATE tbl_Cur