SQLÈçºÎ»ñÈ¡¸¸½áµã

ÈçºÎÓÃSQLÓï¾ä»ñÈ¡µ±Ç°½áµãµÄ¸¸½Úµã£¬°üÀ¨¸¸½áµãµÄ¸¸½áµã¡£

±ÈÈ統ǰ½áµãΪB1£¬rootΪ¸ù½áµã£¬(0)ΪËûµÄID¡£
root(0)
  —A(1)
  —B(2)
      —B1(4)
          —B11(6)
  —C(3)
      —C1(5)
ÔòÎÒÒª»ñÈ¡µÄ²éѯ½á¹ûΪ
id  name
2    B
4    B1
6    B11


½¨±íÊý¾Ý²Î¿¼:

AT_IDΪ½áµãID£¬AT_ParentIDΪ¸¸½áµãID£¬

CREATE TABLE [dbo].[AT_ArticleType](
[AT_ID] [int] IDENTITY(1,1) NOT NULL,
[AT_Name] [nvarchar](50) NULL,
[AT_ParentID] [int] NULL CONSTRAINT [DF_AT_ArticleType_AT_ParentID]  DEFAULT ((0)),
[AT_URL] [nvarchar](200) NULL,
[AT_IsPublish] [int] NULL CONSTRAINT [DF_AT_ArticleType_AT_IsPublish]  DEFAULT ((0)),
[AT_Position] [int] NULL CONSTRAINT [DF_AT_ArticleType_AT_Position]  DEFAULT ((0)),
CONSTRAINT [PK_AT_ArticleType] PRIMARY KEY CLUSTERED
(
[AT_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

-----------------------

INSERT INTO [AT_ArticleType]
          ([AT_Name]
          ,[AT_P