这是用游标做的
declare @payno int (这个类型要和你的payno类型一样)
DECLARE titles_cursor CURSOR FOR
SELECT payno FROM 表
OPEN titles_cursor
FETCH NEXT FROM titles_cursor INTO @payno
WHILE @@FETCH_STATUS = 0
BEGIN
update 表 set mobile=@payno
FETCH NEXT FROM titles_cursor INTO @title
END
CLOSE titles_cursor
DEALLOCATE titles_cursor