代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/408881/11366303
sql rowset.sql
connect hr/hr
DROP TABLE reservation;
CREATE TABLE reservation
(
seatno NUMBER PRIMARY KEY,
tdate DATE,
name VARCHAR2(25),
class VARCHAR2(10)
);
INSERT INTO reservation VALUES (101, to
www.eeworm.com/read/408881/11366395
sql refclient.sql
-- Schema to RUN RefClient.java
drop table student_table;
drop type STUDENT;
create type STUDENT as object (name VARCHAR (30), age NUMBER);
/
create table student_table of STUDENT;
insert into stude
www.eeworm.com/read/408609/11379566
txt sql.txt
1.数据库建立
CREATE DATABASE database_cs
2.建立课程表
create table Info_course (Course_id varchar(50) not null,
Course_name varchar(50) not null,
Teacher_n
www.eeworm.com/read/262947/11383732
sql protype.sql
CREATE TABLE ProType
(TypeId Int Primary Key IDENTITY,
TypeName Varchar(50) NOT NULL,
UpperId Int
)
www.eeworm.com/read/262947/11383734
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/262947/11383736
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/262947/11383737
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/262947/11383739
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/262947/11383740
sql storehouse.sql
CREATE TABLE Storehouse
(StoreId Int Primary Key IDENTITY,
StoreName Varchar(50) NOT NULL,
Describe Varchar(100)
)
www.eeworm.com/read/262947/11383750
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