代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/275972/10779696
sql forum.sql
create table topic(id varchar(30) not null,title varchar(100),author varchar(30),email varchar(50),content varchar(1000),pubtime datetime default getdate(),constraint pk_topic primary key(id));
cre
www.eeworm.com/read/275959/10780964
sql patient.sql
USE Hospital
GO
CREATE TABLE Patient
( Id int IDENTITY PRIMARY KEY,
Name varchar(50),
IDNum varchar(30),
Sex varchar(2),
Age int,
Marry varchar(8)
www.eeworm.com/read/275959/10780965
sql medicine.sql
USE Hospital
GO
CREATE TABLE Medicine
( MedId int IDENTITY PRIMARY KEY,
MedName varchar(50),
TypeId int,
UnitId int,
BuyPrice float, --进货价格，计算利润用
SalePrice
www.eeworm.com/read/275959/10780969
sql basetype.sql
USE Hospital
GO
CREATE TABLE BaseType
(Id int PRIMARY KEY IDENTITY,
TypeId tinyint,
TypeName varchar(30)
)
GO
www.eeworm.com/read/275959/10780977
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/275959/10780981
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/275959/10780983
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/275959/10780984
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/275959/10780991
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