SQL+CE 源代码

alter table dept drop constraint pri_deptno

use master create database pay on (name=pay1 ,filename='c:\Program Files\Microsoft SQL Server\…

create trigger person_update on pay for update as declare @num_rows int select @num_rows=@@rowco…

select person.*,year,month,fact from pay,person where pay.no=person.no and deptno='00102' order by fact desc

create function fun_checkno(@pno char(6)) returns integer as begin declare @num int if exists (select …

alter table pay drop constraint fk_no

select no,fact1=base*1.5+bonus-deduct from pay where no='000001'

sp_addtype d_no,'char(2)','not null' go create table dept1 (deptno d_no, deptname varchar(10) not null)

select person.*,year,month,base,bonus,deduct,fact from person,pay where person.no=pay.no and year=2005 and month…

alter table person add constraint uni_noname unique(no,name)