sql 游标

Rookie

sql 游标

<div id="cnblogs_post_body">declare @Weekday char(50)
declare cur_data cursor for
select travelNum from dbo.TravelBaseInfo WHERE destinations NOT LIKE '%/'
open cur_data
fetch next from cur_data into @Weekday
while(@@fetch_status = 0)
begin
--      set @sql=@id+@displayorder+@type+@code+@url
UPDATE TravelBaseInfo   SET destinations=destinations+'/' WHERE travelNum=@weekday

--print @sql
fetch next from cur_data into @Weekday
end
close cur_data
deallocate cur_data
--加条件了