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
相关问答：
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'亿'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
为什么上一个用varchar转换后就只保留了� ......
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
我们C#做一个窗体 往数据库里插入数据
SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True");
......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
上面一个简单的SQL,执行时间2.6� ......
