代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/446181/7584113
sql 2.2.10.sql
Begin Transaction del
delete from students where sid='800005753';
select * from stu_card;
select * from icbc_card;
Commit Transaction del
www.eeworm.com/read/446181/7584114
sql 2.3.7.sql
use school
insert into worker values ('00003','王浩','1','25','研发部');
www.eeworm.com/read/446181/7584115
sql 2.2.13.sql
use school
create table listen_course (
teacher_id char(6),tname varchar(20),course_id char(4)
constraint PK_listen_course primary key(teacher_id)
)
www.eeworm.com/read/446181/7584116
sql 2.4.3.sql
use school
go
create trigger T3 on Worker
for update
as
if update(number)
begin
print 'Everynumber cannot be changed!'
Rollback Transaction
End
www.eeworm.com/read/446181/7584117
sql 2.4.1.sql
use school
go
create trigger T1 on worker
for insert , update
as
if (select sage from inserted)
www.eeworm.com/read/446181/7584118
sql 2.3.6.sql
use school
go
create rule rule_sex as @value in ('F','M')
go
exec sp_bindrule rule_sex ,'worker.[sex]';
www.eeworm.com/read/446181/7584119
sql 2.1.2.sql
USE School
insert Stu_Union values ( '95002','王嘉','1',23,'CS');
www.eeworm.com/read/446181/7584120
sql 2.1.3.sql
USE School
UPDATE Stu_Union SET sno= NULL WHERE sno='95002';
www.eeworm.com/read/446181/7584121
sql 2.1.8.sql
USE School
Alter Table Scholarship add
Constraint PK_Scholarship Primary key(M_ID)
www.eeworm.com/read/446181/7584122
sql 2.4.2.sql
use school
go
create trigger T2 on worker
for delete
as
if (select number from deleted)='00001'
begin
print 'He is the CEO!Delete Fail!'
Rollback transaction
End