use pay create table pay.dbo.dept (deptno varchar(10) not null unique, deptname varchar(20) not null …
SQL+Server2000 源代码
汇集 SQL+Server2000 相关的电路原理图、PCB工程文件、单片机/FPGA源代码、数据手册与应用设计方案。
select distinct professor from person
sp_unbindefault 'person.professor' drop default default_prof
create unique index sort_deptname on dept(deptname)
delete from person where no='000007'
alter table person add constraint check_sex check(sex in('男','女'))
alter table person add nation char(12) default'中国'
select * from person where sex='男'
insert into dept values('00106','培训部')