代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/129471/14239950
sql basetype.sql
USE Hospital
GO
CREATE TABLE BaseType
(Id int PRIMARY KEY IDENTITY,
TypeId tinyint,
TypeName varchar(30)
)
GO
www.eeworm.com/read/129471/14239953
sql payitems.sql
USE Hospital
GO
CREATE TABLE PayItems
( PayId int IDENTITY PRIMARY KEY,
RegId int, -- 登记编号
ItemId int, -- 收费项目编号
PNum int, -- 收费数量
Price float,-- 销售价格
PType
www.eeworm.com/read/129471/14239954
sql doctor.sql
USE Hospital
GO
CREATE TABLE Doctor
( Id int IDENTITY PRIMARY KEY,
Name varchar(50) NOT NULL,
Sex varchar(2) NOT NULL,
Age int,
DeptId int,
Title varchar(50)
www.eeworm.com/read/129471/14239956
sql items.sql
USE Hospital
GO
CREATE TABLE Items
( ItemId int IDENTITY PRIMARY KEY,
ItemName varchar(50) NOT NULL,
Total int,
UnitId int,
BuyPrice float,
SalePrice float
www.eeworm.com/read/129471/14239958
sql registration.sql
USE Hospital
GO
CREATE TABLE Registration
( RegId int PRIMARY KEY,
PatId int,--患者
DocId int, --医生名称
RegDate varchar(20), --日期
UserName varchar(20) --用户名
)
GO
www.eeworm.com/read/129471/14239964
sql users.sql
USE Hospital
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/129469/14240188
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/129469/14240189
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/129469/14240191
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