代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/446181/7584223
sql 1.2.20.sql
SELECT STUDENTS.SNAME,COURSES.CNAME,CHOICES.SCORE
FROM STUDENTS,COURSES,CHOICES
WHERE STUDENTS.SID=CHOICES.SID AND COURSES.CID=CHOICES.CID AND STUDENTS.SID='850955252'
www.eeworm.com/read/446181/7584224
sql 1.2.33.sql
SELECT X.SID
FROM CHOICES AS X,CHOICES AS Y
WHERE ( X.CID=(
SELECT CID
FROM COURSES
WHERE CNAME='c++'
)AND Y.CID=(
SELECT CID
FROM COU
www.eeworm.com/read/446181/7584225
sql 4.1.8.sql
CREATE PROCEDURE INSERTCOURSEINFO
@courseid char(10),
@coursename varchar(30),
@hour int,
@returnString varchar(100) out
AS
BEGIN TRAN
IF EXISTS( SELECT CID FROM CO
www.eeworm.com/read/446181/7584226
sql 4.1.2.sql
begin tran
update accounts set balance=balance-1000 where accountno='A'
update accounts set balance=balance+1000 where accountno='B'
commit tran
www.eeworm.com/read/446181/7584227
sql 4.4.2.sql
begin tran
select * from courses where cid='10001 '
end tran
www.eeworm.com/read/446181/7584228
sql 4.3.9.sql
set transaction isolation level serializable
BEGIN TRAN
SELECT * FROM TEACHERS WHERE TID='300000000'
WAITFOR DELAY '00:00:10'
SELECT * FROM TEACHERS WHERE TID='300000000'
ROLLBACK TRAN
www.eeworm.com/read/446181/7584229
sql 4.3.2.sql
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
-- 模拟实现脏读
SELECT * FROM TEACHERS WHERE TID='200003125'
IF @@ROWCOUNT0
BEGIN
WAITFOR DELAY '00:00:20'
-- PRINT 模拟实现不可重复读
www.eeworm.com/read/446181/7584230
sql 4.1.5.sql
CREATE TRIGGER TD_COURSE ON COURSES
FOR DELETE
AS
DECLARE @INFO VARCHAR(255)
SELECT @INFO='触发器中的事务数据为：'+CONVERT(VARCHAR(2),@@TRANCOUNT)
PRINT @INFO
RETURN
www.eeworm.com/read/446181/7584231
sql 4.3.10.sql
set transaction isolation level serializable
INSERT INTO TEACHERS VALUES('300000000','AA','BBB@163.COM',5000)
www.eeworm.com/read/446181/7584232
sql 4.4.1.sql
begin tran
update courses set hour=80 where cid='10001 '