SQL+CE 源代码

create trigger person_insert on pay for insert as declare @num_rows int select @num_rows=@@rowco…

update pay set base=base+200 where no='000005' update pay set base=1850 where no='000006'

alter table person drop fk_deptno alter table person add constraint fk_deptno foreign key(deptno) refer…

sp_grantlogin 'workgroup\guest05'

delete pay where no='000006'

create view dbo.view_person(no,name,sex,professor,deptno) as select no,name,sex,professor,deptno from dbo.pe…

select* from person where no in(select no from pay where year=2005 and month=1 and …

alter table dept add constraint pri_deptno primary key(deptno)

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

sp_unbindrule'person.professor' drop rule rule_prof