代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/169887/9834221
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/169887/9834225
sql basetype.sql
USE Hospital
GO
CREATE TABLE BaseType
(Id int PRIMARY KEY IDENTITY,
TypeId tinyint,
TypeName varchar(30)
)
GO
www.eeworm.com/read/169887/9834230
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/169887/9834231
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/169887/9834233
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/169887/9834234
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/169887/9834240
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/169886/9834454
sql fac.sql
use master
create database fac
go
-------------------------------------------------------------------------------
use fac
create table Cp--菜谱表
( cpid int identity(1,1) not null,--序号
cpname v
www.eeworm.com/read/169885/9834670
sql repair.sql
USE Assets
GO
CREATE TABLE Repair
(Id int PRIMARY KEY IDENTITY,
Aid varchar(30) NOT NULL,
RepairDate varchar(20),
Unit varchar(100),
Reason varchar(50),
Status tinyint,