1,178
社区成员
发帖
与我相关
我的任务
分享
if not exists (select 1 from syscolumns where id=object_id('dic_rpt') and name='ord')
begin
drop table dic_rpt
end
go
if not exists (select 1 from sysobjects where id = object_id('dic_rpt') and type = 'U')
begin
CREATE TABLE dic_rpt(
[id] [int] IDENTITY(1,1) NOT NULL,
[ord] [int] NOT NULL,
[tabname] [varchar](100) NOT NULL,
[rb] [varchar](1) NULL,
[xb] [varchar](1) NULL,
[yb] [varchar](1) NULL,
[jb] [varchar](1) NULL,
[nb] [varchar](1) NULL,
CONSTRAINT [PK_dic_rpt] PRIMARY KEY NONCLUSTERED
(
[id]
) ON [PRIMARY]
) ON [PRIMARY]
end
go
insert into dic_rpt(ord,tabname,rb,xb,yb,jb,nb) values(1,'机报11','','Y','Y','Y','Y')
insert into dic_rpt(ord,tabname,rb,xb,yb,jb,nb) values(2,'机报12','','Y','Y','Y','Y')