把“on [primary]”去掉试试!!
begin transaction
set quoted_identifier on
set transaction isolation level serializable
set arithabort on
set numeric_roundabort off
set concat_null_yields_null on
set ansi_nulls on
set ansi_padding on
set ansi_warnings on
commit
begin transaction
create table dbo.gpczb
(
czbhm int not null,
gph int not null,
ygbh int not null,
czrq datetime not null,
ghrq datetime not null,
sfshy bit not null,
yj money not null
)go
alter table dbo.gpczb add constraint
df_gpczb_sfshy default 0 for sfshy
go
alter table dbo.gpczb add constraint
pk_gpczb primary key clustered
(
czbhm
)go
commit
begin transaction
set quoted_identifier on
set transaction isolation level serializable
set arithabort on
set numeric_roundabort off
set concat_null_yields_null on
set ansi_nulls on
set ansi_padding on
set ansi_warnings on
commit
begin transaction
create table dbo.gpczb
(
czbhm int not null,
gph int not null,
ygbh int not null,
czrq datetime not null,
ghrq datetime not null,
sfshy bit not null,
yj money not null
)go
alter table dbo.gpczb add constraint
df_gpczb_sfshy default 0 for sfshy
go
alter table dbo.gpczb add constraint
pk_gpczb primary key clustered
(
czbhm
)go
commit
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货