SQL+Server2000 源代码

alter table pay add constraint fk_no foreign key(no) references person(no)

sp_unbindrule'person.professor' drop rule rule_prof

drop index pay.sort_fact

create

declare @age int execute pro_calage '000001',@age output print @age

update dept set deptno='00108' where deptno='00101'

create clustered index sort_fact on pay(fact)

alter database pay add file (name=pay2 ,filename='c:\Program Files\Microsoft SQL Server\MSSQL\Dat…

insert into view_person values ('000010','柳芸','女',null,'00103')

select deptno,avg(bonus) from pay,person where pay.no=person.no and year=2005 and month=1 group by deptno …