SQL+CE 源代码

declare @num int select @num=dbo.fun_checkno('000008') if @num=0 insert pay values('000008',2005,2,2200,280,12.4)

sp_helptext default_prof

create rule rule_prof as @a in('初级','中级','高级') go sp_bindrule'rule_prof','person.professor'

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

delete from dept where deptno='00102'

insert into pay values('000012','2005','2','1800','400','152.6')

create view view_pay as select year,month,person.no,name,sex,professor,deptname,base,bonus,deduct,fact from …

select deptno as 部门,sum(fact) as 总额 from pay,person where pay.no=person.no and year=2005 group by deptno

create index sort_yearmonth on pay(year,month)

select * from person where sex='Ů'and deptno='00102'