declare @sql varchar(max)
DECLARE @id int
declare @f5 varchar(50)
DECLARE vend_cursor CURSOR
FOR select id,field_5 from hpclass
OPEN vend_cursor
FETCH NEXT FROM vend_cursor into @id,@f5;
set @sql=''
WHILE(@@fetch_status=0)
BEGIN
set @sql +='update hpclass set field_5='''+@f5+''' where id='+cast(@id as varchar(10))+';';
FETCH NEXT FROM vend_cursor into @id,@f5;
END
close vend_cursor --关闭游标
deallocate vend_cursor
print @sql
根据现有数据库值,循环拼接SQL语句
最新推荐文章于 2024-08-10 23:17:37 发布