LINQ+to+SQL 源代码

insert into person values ('000008','孙烨','女','1982-6-25','初级','00102') insert into person values ('000009','苏友','…

create trigger person_del on person for delete as if @@rowcount=0 return delete pay …

alter table person drop constraint uni_noname

exec sp_addlogin 'guest05','12345','paydata'

create trigger person_update on person for update as if @@rowcount=0 return update p…

create table paydata.dbo.person1 ( no char(6) not null primary key, name char(10) not null, sex char(2…

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