代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/179244/9363766
sql area.sql
CREATE TABLE Area
(AreaId Int Primary Key IDENTITY,
AreaName Varchar(40) NOT NULL,
AreaType Smallint NOT NULL
)
www.eeworm.com/read/179244/9363769
sql users.sql
CREATE TABLE Users
(UserName Varchar(40) Primary Key,
Pwd Varchar(40) NOT NULL,
EmpName Varchar(40)
);
INSERT INTO Users Values('Admin', 'Admin', 'Admin')
www.eeworm.com/read/179244/9363772
sql tline.sql
CREATE TABLE tline
(lid Int Primary Key,
lname Varchar(50),
lday Smallint,
ltype Smallint,
insCom Varchar(40),
insFee Decimal(8, 2),
otherCost Decimal(8, 2),
tourPay D
www.eeworm.com/read/375330/9363869
sql new.sql
exec sp_addlogin 'SGteacher','123456','StuGrade'
exec sp_addlogin 'SGstudent','123','StuGrade'
use StuGrade
go
exec sp_grantdbaccess N'SGteacher'
exec sp_grantdbaccess N'SGstudent'
exec sp_addro
www.eeworm.com/read/179243/9363920
sql students.sql
CREATE TABLE Students
(Student_Id Int Primary Key,
Student_Name Varchar(50) NOT NULL,
Photo Image,
Sex Char(2),
Nationality Varchar(40),
Birth Varchar(20),
Politic
www.eeworm.com/read/179243/9363922
sql experience.sql
CREATE TABLE Experience
(ExpId Int Primary Key IDENTITY,
Student_Id Int NOT NULL,
Start_Date Char(10),
End_Date Char(10),
School Varchar(50),
Title Varchar(20)
)
www.eeworm.com/read/179243/9363923
sql lessons.sql
CREATE TABLE Lessons
(LessonId Int Primary Key IDENTITY,
LessonName Varchar(100),
Term Varchar(20),
Teacher Varchar(20),
Hours Tinyint,
LessonType Varchar(20)
)
www.eeworm.com/read/179243/9363924
sql change.sql
CREATE TABLE Change
(ChangeId Int Primary Key IDENTITY,
Student_Id Int NOT NULL,
ChangeType Tinyint,
ChangeDate Char(10),
OriClass Int,
NewSchool Varchar(50),
NewClass Int
www.eeworm.com/read/179243/9363925
sql studentsys.sql
USE master
GO
CREATE DATABASE StudentSys
ON
PRIMARY ( NAME = St1,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\StData1.mdf',
SIZE = 10MB,
MAXSIZE = 200,
www.eeworm.com/read/179243/9363926
sql classes.sql
CREATE TABLE Classes
(Class_Id Int Primary Key,
Class_Name Varchar(40) NOT NULL,
Describe Varchar(400),
UpperId SmallInt NOT NULL
)