代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/446181/7584264
sql 7.4.1.sql
USE School
GO
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'IX_sid')
DROP INDEX CHOICES.IX_sid
GO
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'IX_tid')
DROP INDEX CHOICES.IX_tid
www.eeworm.com/read/446181/7584265
sql 7.1.1.sql
USE SCHOOL
GO
CREATE TABLE TEST (
ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL DEFAULT(NEWID()) PRIMARY KEY,
NAME VARCHAR(50) NOT NULL,
AGE INT,
PHONE CHAR(20) NOT NULL
)
GO
www.eeworm.com/read/446181/7584266
sql 7.5.2.sql
USE School
IF NOT EXISTS (SELECT name FROM sysindexes WHERE name = 'st_ind')
CREATE INDEX st_ind ON STUDENTS(grade)
GO
SET STATISTICS IO ON
GO
SET STATISTICS TIME ON
GO
SELECT * FROM STUDENTS
www.eeworm.com/read/446181/7584267
sql 7.6.1.sql
USE School
IF NOT EXISTS (SELECT name FROM sysindexes WHERE name = 'ix_sid’)
CREATE INDEX ix_sid ON CHOICES(sid)
GO
IF NOT EXISTS (SELECT name FROM sysindexes WHERE name = 'ix_tid’)
CREATE INDEX
www.eeworm.com/read/446181/7584268
sql 7.3.3.sql
USE School
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'IX_sid')
DROP INDEX CHOICES.IX_sid
GO
CREATE CLUSTERED INDEX IX_sid ON CHOICES(SID)
GO
SET STATISTICS IO ON
GO
SET STATISTICS TI
www.eeworm.com/read/446181/7584269
sql 7.6.4.sql
SET SHOWPLAN_ALL ON
GO
SET STATISTICS IO ON
GO
SET STATISTICS TIME ON
GO
select * from CHOICES where sid between '850000000' and '889000000' and tid between '229500000' and '229900000'
GO
www.eeworm.com/read/446181/7584270
sql 7.1.3.sql
USE SCHOOL
GO
CREATE CLUSTERED INDEX IX_NAME ON TEST(NAME)
GO
www.eeworm.com/read/446181/7584271
sql 7.6.5.sql
SET SHOWPLAN_ALL ON
GO
SET STATISTICS IO ON
GO
SET STATISTICS TIME ON
GO
select * from CHOICES where sid between '880000000' and '889000000' and tid between '229850000' and '229900000'
GO
www.eeworm.com/read/446181/7584272
sql 7.9.1.sql
USE SCHOOL
GO
CREATE INDEX IX_SID_TID ON CHOICES(SID,TID)
GO
www.eeworm.com/read/446181/7584273
sql 7.3.2.sql
USE SCHOOL
IF NOT EXISTS (SELECT name FROM sysindexes WHERE name = 'IX_sid’)
CREATE INDEX IX_sid
ON CHOICES(SID)
GO
SET STATISTICS IO ON
GO
SET STATISTICS TIME ON
GO
select * from choices wh