SQL+CE 源代码

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 …

select person.name,pay.*,deptname from pay,person,dept where pay.no=person.no and person.deptno=dept.deptno and dept…

alter table pay add constraint pri_ymn primary key(no,year,month)