代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/162894/10259826
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/162894/10259829
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/162894/10259834
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/162894/10259836
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/162894/10259837
sql storehouse.sql
USE Stock
GO
CREATE TABLE Storehouse
(Sid int PRIMARY KEY IDENTITY,
Sname varchar(50) NOT NULL,
Memo varchar(100)
)
GO
www.eeworm.com/read/162894/10259853
sql valid.sql
USE Stock
GO
CREATE VIEW dbo.Valid
AS
SELECT dbo.ProInStore.SpId AS 库存记录编号, dbo.Product.Pname AS 产品名称,
dbo.ProInStore.Pprice AS 产品价格, dbo.ProInStore.Pnum AS 产品数量,
dbo.ProInStore.Ma
www.eeworm.com/read/162894/10259857
sql proinstore.sql
USE Stock
GO
CREATE TABLE ProInStore
(SpId int PRIMARY KEY IDENTITY,
Pid int NOT NULL,
Pprice decimal(15, 2),
Pnum int,
MakeDate char(10),
Sid int
)
GO
www.eeworm.com/read/162894/10259859
sql storein.sql
USE Stock
GO
CREATE TABLE StoreIn
(SiType varchar(20),
Pid int,
MakeDate char(10),
Pprice decimal(15,2),
Pnum int,
Cid int,
Sid int,
EmpName varchar(50),
OptDate c
www.eeworm.com/read/162894/10259863
sql users.sql
USE Stock
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