sql With As 递归实现树形结构数据初始化
CREATE TABLE [dbo].[PARAM_PARAM]
(
[ID] [CHAR](12),
[PARENTID] [CHAR](12),
[CLASSID] [CHAR](5),
[GROUPID] [CHAR](6),
[CODE] [VARCHAR](255),
[NAME] [VARCHAR](255),
[VALID] [CHAR](1),
[DESCRIPTION] [VARCHAR](1000),
[BRIEFNAME] [VARCHAR]
原创
2019-08-30 21:55:48 ·
672 阅读 ·
0 评论