--查询分析器连接到SQL服务器,然后复制下面的语句到查询分析器中,按F5执行即可:--创建数据库
create database tree
gouse tree
goif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_tree]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_tree]
GOCREATE TABLE [dbo].[t_tree] (
[nodeid] [int] NOT NULL ,
[parentid] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[mytext] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[location] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[order_id] [int] NULL
) ON [PRIMARY]
GOALTER TABLE [dbo].[t_tree] WITH NOCHECK ADD
CONSTRAINT [PK_tree] PRIMARY KEY CLUSTERED
(
[nodeid]
) ON [PRIMARY]
GO
create database tree
gouse tree
goif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_tree]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_tree]
GOCREATE TABLE [dbo].[t_tree] (
[nodeid] [int] NOT NULL ,
[parentid] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[mytext] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[location] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[order_id] [int] NULL
) ON [PRIMARY]
GOALTER TABLE [dbo].[t_tree] WITH NOCHECK ADD
CONSTRAINT [PK_tree] PRIMARY KEY CLUSTERED
(
[nodeid]
) ON [PRIMARY]
GO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货