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 ·
690 阅读 ·
0 评论