其它/编程 删除合同段SQL

	-- 删除合同段SQL

	-- 更改父节点
	UPDATE [dbo].[tb_Projects] SET ParentId='510321' WHERE ParentId='510322'

	-- 删除合同段
	DELETE FROM [dbo].[tb_Projects] WHERE ProID='510322'
	
	-- level降级
	UPDATE [dbo].[tb_Projects] SET [Level]=[Level]-1 WHERE ProID > 510321

	-- 编码
	UPDATE [dbo].[tb_Projects]
	SET ProjectCode = '01.'+SUBSTRING(ProjectCode, 7, LEN(ProjectCode)-6)
	FROM [dbo].[tb_Projects]
	WHERE ProID > 510321