代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/169885/9834673
sql type.sql
USE Assets
GO
CREATE TABLE Type
(TypeId int PRIMARY KEY IDENTITY,
TypeName varchar(30) NOT NULL
)
GO
www.eeworm.com/read/169885/9834681
sql departments.sql
USE Assets
GO
CREATE TABLE Departments
(DeptId int PRIMARY KEY IDENTITY,
DeptName varchar(30) NOT NULL
)
GO
www.eeworm.com/read/169885/9834684
sql users.sql
USE Assets
GO
CREATE TABLE Users
(UserName varchar(40) PRIMARY KEY,
Pwd varchar(40) NOT NULL,
User_Type tinyint NOT NULL
)
GO
INSERT INTO Users Values('Admin', '888888', 1)
GO
www.eeworm.com/read/169884/9834697
sql protype.sql
USE Stock
GO
CREATE TABLE ProType
(TypeId int PRIMARY KEY IDENTITY,
TypeName varchar(50) NOT NULL,
UpperId int
)
GO
www.eeworm.com/read/169884/9834699
sql takeout.sql
USE Stock
GO
CREATE TABLE TakeOut
(Ttype varchar(20) NOT NULL,
Pid int,
Pprice decimal(15,2),
Pnum int,
Cid int,
Sid int,
EmpName varchar(50),
OptDate char(20)
)
G
www.eeworm.com/read/169884/9834701
sql product.sql
USE Stock
GO
CREATE TABLE Product
(Pid int PRIMARY KEY IDENTITY,
Pname varchar(50) NOT NULL,
TypeId int,
Pstyle varchar(50),
Punit varchar(10),
Pprice decimal(15, 2),
P
www.eeworm.com/read/169884/9834703
sql client.sql
USE Stock
GO
CREATE TABLE Client
(Cid int PRIMARY KEY IDENTITY,
Cname varchar(50) NOT NULL,
Ctype tinyint,
Contact varchar(30),
Address varchar(50),
Postcode varchar(10),
www.eeworm.com/read/169884/9834704
sql storehouse.sql
USE Stock
GO
CREATE TABLE Storehouse
(Sid int PRIMARY KEY IDENTITY,
Sname varchar(50) NOT NULL,
Memo varchar(100)
)
GO