数据库循环
摘要：
数据库循环案例--修改OA的个人文件夹目录declare @i intdeclare @path varchar(255)set @i = 2while @i < 20begin select @path = user_path from basic_user where user_id = @i print cast(@i as nvarchar) + '---' + @path if(LOWER(substring(@path, 1, 1)) = 's') update basic_user set user_path = 'H:/kingde 阅读全文
posted @ 2013-01-17 17:43 hzm_frank 阅读(189) 评论(0) 推荐(0) 编辑
