2012年8月2日
sql 游标
摘要： declare @Weekday char(50)declare cur_data cursor forselect travelNum from dbo.TravelBaseInfo WHERE destinations NOT LIKE '%/'open cur_datafetch next from cur_data into @Weekdaywhile(@@fetch_status = 0) begin-- set @sql=@id+@displayorder+@type+@code+@urlUPDATE TravelBaseInfo SET destinations= 阅读全文
posted @ 2012-08-02 14:10 Rookier 阅读(238) 评论(0) 推荐(0)