代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/446181/7584244
sql 4.3.5.sql
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
-- 初始状态
BEGIN TRAN
SELECT * FROM TEACHERS WHERE TID='200003125'
IF @@ROWCOUNT0
BEGIN
WAITFOR DELAY '00:00:20'
-- PRINT 模拟实现不可重复
www.eeworm.com/read/446181/7584245
sql 4.1.1.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/7584246
sql 4.1.9.sql
CREATE PROCEDURE UPDATECOURSEINFO
@courseid char(10),
@coursename varchar(30),
@hour int,
@returnString varchar(100) out
AS
BEGIN TRAN
IF NOT EXISTS( SELECT CID FR
www.eeworm.com/read/446181/7584247
sql 4.3.4.sql
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
UPDATE TEACHERS SET SALARY=4200 WHERE TID='200003125'
www.eeworm.com/read/446181/7584248
sql 7.4.3.sql
USE SCHOOL
GO
SET STATISTICS TIME ON
GO
CREATE clustered INDEX IX_sid ON CHOICES(SID)
GO
www.eeworm.com/read/446181/7584249
sql 7.7.4.sql
USE SCHOOL
GO
SET STATISTICS TIME ON
GO
SET SHOWPLAN_ALL ON
GO
select score from STUDENTS,CHOICES where STUDENTS.grade = 2000 and STUDENTS.sid = CHOICES.sid
GO
www.eeworm.com/read/446181/7584250
sql 7.2.1.sql
USE School
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'cs_cid_ind')
DROP INDEX CHOICES.cs_cid_ind
GO
SET STATISTICS IO ON
GO
SET STATISTICS TIME ON
GO
SELECT COUNT(*)
FROM CHOICES
W
www.eeworm.com/read/446181/7584251
sql 7.9.3.sql
DROP INDEX CHOICES.IX_SID_TID
GO
CREATE INDEX IX_TID_SID ON CHOICES(TID,SID)
GO
www.eeworm.com/read/446181/7584252
sql 7.8.1.sql
USE SCHOOL
GO
CREATE TABLE TEST2 (
ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL DEFAULT(NEWID()) PRIMARY KEY NONCLUSTERED,
NAME VARCHAR(50) NOT NULL,
AGE INT,
RENT INT NOT NULL
)
GO
www.eeworm.com/read/446181/7584253
sql 7.8.11.sql
DROP INDEX TEST2.IX_RENT
GO
CREATE INDEX IX_RENT ON TEST2(RENT) WITH FILLFACTOR=100
GO