DBstar+SQL 源代码

drop view view_person

update view_person set professor='高级' where name='罗玮'

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\…