摘要：
/* sql2005遍历表(方法1)insert into 数据表(userid,adddate) values((select userid from 用户表),date);*//*sql2005 表变量遍历表(方法2)*/--表变量declare @i intdeclare @ChannelID intdeclare @ChannelUpdateRoomCount int --nvarchar(50)--遍历set @i=(select min(XH_ChannelID) from XH_Channel where XH_ChannelState=0)--遍历表中的每一行while (@i 阅读全文
posted @ 2013-12-22 10:44 且行且思 阅读(577) 评论(0) 推荐(0) 编辑