if object_id ('Board','u') is not null
drop table Board
go
execute('create table Board
(
boardId int not null,
boardName varchar(50) not null,
parentId int not null,
constraint df_parentId default(0) for parentId
)');
go
出错提示:'for' 附近有语法错误。(倒数第三行)看不出来哪错了
drop table Board
go
execute('create table Board
(
boardId int not null,
boardName varchar(50) not null,
parentId int not null,
constraint df_parentId default(0) for parentId
)');
go
出错提示:'for' 附近有语法错误。(倒数第三行)看不出来哪错了
drop table Board
go
create table Board
(
boardId int not null,
boardName varchar(50) not null,
parentId int not null default(0)
--constraint df_parentId default(0) for parentId
)
drop table Board
这样行
if object_id ('Board','u') is not null
drop table Board
go
execute('create table Board
(
boardId int not null,
boardName varchar(50) not null,
parentId int not null default(0)
)');
go
drop table Board
go
execute('create table Board
(
boardId int not null,
boardName varchar(50) not null,
parentId int not null constraint df_parentId default(0)
)');
go
(
boardId int not null,
boardName varchar(50) not null,
parentId int not null constraint df_parentId default(0)
)