简单的游标实列
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