很抱歉，您要访问的页面无法正确显示，可能是因为如下原因：
1 . 系统过于繁忙，请点击浏览器的“刷新”按钮，或稍后再试。
2 . 您输入的网址有误，请重新检查您输入的网址。
3 . 此页面已经删除，请访问其他页面。
DECLARE @id int,@fatherid int,@name nvarchar(50) SET @id= CREATE TABLE #temp(ID int,FatherID int,[Name] nvarchar(50)) SELECT @id = ID,@fatherid = FatherID,@name = [Name] FROM ShopNum1_ProductCategory WHERE ID = @id INSERT INTO #temp(ID,FatherID,[Name]) VALUES(@id,@fatherid,@name) WHILE ((SELECT COUNT(1) FROM ShopNum1_ProductCategory WHERE ID = @fatherid) > 0) BEGIN SELECT @id = ID,@fatherid = FatherID,@name = [Name] FROM ShopNum1_ProductCategory WHERE ID = @fatherid INSERT INTO #temp(ID,FatherID,[Name]) VALUES(@id,@fatherid,@name) END SELECT * FROM #temp ORDER BY FatherID ASC_关键字 'CREATE' 附近有语法错误。