declare @SQLText varchar(3000)
declare @id varchar(100)
declare @name varchar(100)
declare @last_id varchar(100)
declare @last_name varchar(100)
declare myCursor cursor for select id, inparam from sysmodule order by id
open myCursor
fetch next from myCursor into @id, @name
while @@fetch_status=0
begin
Set @SQLText = 'id=' + ''''+@id+''''
print @SQLText
if(@name = '')
begin
Set @SQLText = 'update sysmodule set inparam=' + ''''+@last_name+'''' + ' where id = ' + ''''+@id+''''
print @SQLText
end
else
begin
set @last_name = @name
end
fetch next from myCursor into @id, @name
end
close myCursor
deallocate myCursor
//----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
今天还遇到一个巨奇怪的问题
sql条件里面有个convert(float, field) > 0.8
但是当表里面含有不能转换的字符的时候, 就出错了。即便是前面添加了过滤的条件, 也不能使条件成立