就像题目那样,我建表的时候if not exists用不了,但我在mysql可以用,是sql serve需要什么别的设置吗还是什么
试试这个
if not exists (select * from sysobjects where id = object_id('S') and OBJECTPROPERTY(id, 'IsUserTable') = 1)
create table S(
Sno int primary key,
Sname varchar(10) not null,
Ssex char(2) check(Ssex='男' or Ssex='女'),
Sage smallint,
Sdept varchar(20) default('计算机系')
)