代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/143219/12888265
sql summary.sql
CREATE TABLE Summary
(SumId Int Primary Key IDENTITY,
ProjId Int NOT NULL,
Title Varchar(40),
Body Varchar(600),
Author Varchar(50),
CreateDate Char(10)
)
www.eeworm.com/read/143219/12888268
sql users.sql
CREATE TABLE Users
(UserName Varchar(20) Primary Key,
UserPwd Varchar(20),
UserType Tinyint,
Ename Varchar(50)
)
INSERT INTO Users Values('Admin', 'Admin',1,'Admin')
INSERT INTO User
www.eeworm.com/read/143217/12888469
sql protype.sql
CREATE TABLE ProType
(TypeId Int Primary Key IDENTITY,
TypeName Varchar(50) NOT NULL,
UpperId Int
)
www.eeworm.com/read/143217/12888473
sql takeout.sql
CREATE TABLE TakeOut
(TakeoutId Int Primary Key,
TakeoutType Varchar(20) NOT NULL,
ProId Int,
ProPrice Decimal(15,2),
ProNum Int,
ClientId Int,
StoreId Int,
EmpName Varc
www.eeworm.com/read/143217/12888476
sql product.sql
CREATE TABLE Product
(ProId Int Primary Key IDENTITY,
ProName Varchar(50) NOT NULL,
TypeId Int,
ProStyle Varchar(50),
ProUnit Varchar(10),
ProPrice Decimal(15, 2),
ProLow
www.eeworm.com/read/143217/12888478
sql stocks.sql
USE master
GO
CREATE DATABASE Stocks
ON
PRIMARY ( NAME = Stock1,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\StockData1.mdf',
SIZE = 10MB,
MAXSIZE = 200,
www.eeworm.com/read/143217/12888480
sql client.sql
CREATE TABLE Client
(ClientId Int Primary Key IDENTITY,
ClientName Varchar(50) NOT NULL,
ClientType Tinyint,
Contact Varchar(30),
Address Varchar(50),
Postcode Varchar(10),
www.eeworm.com/read/143217/12888481
sql storehouse.sql
CREATE TABLE Storehouse
(StoreId Int Primary Key IDENTITY,
StoreName Varchar(50) NOT NULL,
Describe Varchar(100)
)
www.eeworm.com/read/143217/12888492
sql valid.sql
CREATE VIEW dbo.Valid
AS
SELECT dbo.ProInStore.StoreProId AS 仓库存储编号, dbo.Product.ProName AS 产品名称,
dbo.ProInStore.ProPrice AS 产品价格, dbo.ProInStore.ProNum AS 产品数量,
dbo.ProInStore.Creat
www.eeworm.com/read/143217/12888495
sql proinstore.sql
CREATE TABLE ProInStore
(StoreProId Int Primary Key IDENTITY,
ProId Int NOT NULL,
ProPrice Decimal(15, 2),
ProNum Int,
ClientId Int,
CreateDate Char(10),
StoreId Int
)