代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/446181/7584234
sql 4.3.3.sql
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
-- 初始状态
BEGIN TRAN
SELECT * FROM TEACHERS WHERE TID='200003125'
IF @@ROWCOUNT0
BEGIN
WAITFOR DELAY '00:00:20'
-- PRINT 模拟实现不可重复读
www.eeworm.com/read/446181/7584235
sql 4.3.8.sql
set transaction isolation level repeatable read
delete FROM TEACHERS WHERE TID='300000000'
www.eeworm.com/read/446181/7584236
sql 4.3.6.sql
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
UPDATE TEACHERS SET SALARY=4200 WHERE TID='200003125'
www.eeworm.com/read/446181/7584237
sql 4.3.7.sql
set transaction isolation level repeatable read
BEGIN TRAN
SELECT * FROM TEACHERS WHERE TID='300000000 '
IF @@ROWCOUNT0
BEGIN
WAITFOR DELAY '00:00:10'
SELECT * FROM TEACHERS W
www.eeworm.com/read/446181/7584238
sql 4.1.7.sql
BEGIN TRAN tran_upd_courses
update courses
set hour=45
where cid='10051 '
-----设置事务保存点
SAVE TRAN tran_upd_courses_done
insert into teachers
values('1234567890','zs','my@zs
www.eeworm.com/read/446181/7584239
sql 4.1.4.sql
SELECT 'BEFORE TRANSACTION: ' AS HINT,@@TRANCOUNT AS TRANACTIONCOUNT
BEGIN TRAN
SELECT 'THE FIRST TRANSACTION STARTS: ' AS HINT,@@TRANCOUNT AS TRANACTIONCOUNT
SELECT TOP 3 *
www.eeworm.com/read/446181/7584240
sql 4.4.3.sql
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
BEGIN TRAN
SELECT * FROM TEACHERS WHERE TID='200003125'
WAITFOR DELAY '00:00:05'
UPDATE TEACHERS SET SALARY=4000 WHERE TID='200003125'
www.eeworm.com/read/446181/7584241
sql 4.3.1.sql
BEGIN TRAN
UPDATE TEACHERS SET SALARY=4200 WHERE TID='200003125'
WAITFOR DELAY '00:00:20' --延时20秒
SELECT * FROM TEACHERS WHERE TID='200003125'
ROLLBACK TRAN
www.eeworm.com/read/446181/7584242
sql 4.1.6.sql
BEGIN TRAN tran_upd_courses
update courses
set hour=60
where cid='10051 '
BEGIN TRAN tran_upd_teachers
insert into teachers
values('1234567890','zs','my@zsu.edu.cn'
www.eeworm.com/read/446181/7584243
sql 4.1.3.sql
Update courses set hour=96 where cid='10001 '
Insert teachers values('1234567890','MY','MY@ZSU.EDU.CN',3000)
Select top 10 * from teachers (HoldLock)
go