按照一定规则批量修改表中新增字段的值

用户注册

投稿取消

文章分类:

还能输入300字

上传中....

热门文章更多>>

标签更多>>

word左右居中纵向分布 word左右居中对齐 word左右居中对齐怎么设置 word标题回车后为正文 word标题回车后直接分页 word标题回车后中间空了好大一段 word里面行距怎么调整无法缩小 word里面行距一直很大 word里面行距怎么设置在哪里 word试卷格式文档怎么打印 word试卷格式排版 word中隐藏文字打印 word中隐藏文字快捷键 word中隐藏文字在哪里

专题更多>>

最新文章更多>>

逝去的快乐呢

按照一定规则批量修改表中新增字段的值

create procedure proc_dept
as
declare @cursor cursor,
@id varchar(50),
@pid varchar(100)
begin
	set @cursor = cursor
	for
	select deparet_id, parent_deparet_id from dbo.tb_department_tree order by sequence;
	open @cursor
	fetch next from @cursor into @id, @pid;
	while(@@FETCH_STATUS = 0)
	begin
		if(@pid is null) 
		begin
			update tb_department_tree set scope = @id, tlevel = 1, tpath = @id where deparet_id = @id;
		end
		else
		begin 
			update tb_department_tree set tlevel = (select tlevel from tb_department_tree where deparet_id = @pid)+1, tpath = (select tpath from tb_department_tree where deparet_id = @pid)+'-'+@id where deparet_id = @id;
			update tb_department_tree set scope =(select SUBSTRING(tpath, 0, CHARINDEX('-',tpath, 0)) from tb_department_tree where deparet_id = @id) from tb_department_tree where deparet_id = @id;
		end;
		fetch next from @cursor into @id, @pid;
	end;
	close @cursor;
end;

exec proc_dept;

drop procedure proc_dept;