摘要:
这游标的写法,久了没写就确实忘记格式了,老实点记录下来吧...declare @Province varchar(50);declare @ProvinceCode varchar(50);declare myCursor cursor for (select distinct Province,ProvinceCode from t_PublicRegion)open myCursorfetch next from myCursor into @Province,@ProvinceCodewhile(@@FETCH_STATUS=0)beginprint @Province+@Provinc 阅读全文
posted @ 2013-03-21 13:41 車車 阅读(161) 评论(0) 推荐(0) 编辑