Declare Id Int Set Id 0; ---在此修改父节点 With RootNodeCTE(D_ID,D_FatherID,D_Name,lv) As ( Select D_ID,D_FatherID,D_Name,0 as lv From [LFBMP.LDS].[dbo].[LDS.Dictionary] Where D_FatherID In (Id) Union All Select [LFBMP.LDS].[dbo].[LDS.Dictionary].D_ID,[L…
效果图: 数据库: 操作树的示意图: 控制器代码: using Dw.Business;
using Dw.Entity;
using Dw.Utilities;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web.Mvc;
usin…
USE [master] GO ALTER DATABASE data SET RECOVERY SIMPLE WITH NO_WAIT GO ALTER DATABASE data SET RECOVERY SIMPLE --简单模式 GO USE data GO DBCC SHRINKFILE (Ndata_log , 11, TRUNCATEONLY) GO USE [master] GO ALTER DATABASE data SET RECOVERY FULL W…