DECLARE @TL_NANME VARCHAR(15), @TL_FULLNAME NVARCHAR(50)
DECLARE CUR_NB CURSOR FOR SELECT TLNANME, TLFullName FROM TL_USER_V2
OPEN CUR_NB
FETCH NEXT FROM CUR_NB INTO @TL_NANME, @TL_FULLNAME
WHILE @@FETCH_STATUS = 0
BEGIN
UPDATE TL_USER SET TLFullName =@TL_FULLNAME WHERE TLNANME =@TL_NANME
FETCH NEXT FROM CUR_NB INTO @TL_NANME, @TL_FULLNAME
END
CLOSE CUR_NB
DEALLOCATE CUR_NB