代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/466091/7044436
sql createtable.sql
use
SMIS
go
create table student(
学籍号 nvarchar(10) not null primary key,
姓名 nvarchar(8) not null,
性别 nvarchar(2) default '男' check(性别 in('男','女')),
出生年月 nvarchar(7) null
)
go
create
www.eeworm.com/read/466091/7044437
sql createcourceview.sql
create view courseView1(课程,人数)
as
select 课程,count(*) as 人数
from classView1
group by 课程
go
create view courseView2(课程,人数)
as
select 课程,count(*) as 人数
from classView2
group by 课程
go
cr
www.eeworm.com/read/465547/7049639
txt sql.txt
SQL语句集锦
--语 句 功 能
--数据操作
SELECT --从数据库表中检索数据行和列
INSERT --向数据库表添加新数据行
DELETE --从数据库表中删除数据行
UPDATE --更新数据库表中的数据
--数据定义
CREATE TABLE --创建
www.eeworm.com/read/465498/7055716
sql empdata.sql
create database if not exists employees; use employees; drop table if exists emptable; create table if not exists emptable (empid char(5) primary key,
www.eeworm.com/read/465177/7059162
sql check.sql
create database student
on primary
(
/*--数据文件的具体描述--*/
name='student_data', --主数据库的物理名称
filename='E:\STUDY\大三下学期\数据库\data\student.mdf',
size=15MB, --主数据库的初始大小
maxsize=1
www.eeworm.com/read/465237/7059714
sql epet.sql
www.eeworm.com/read/464911/7062654
sql createdb.sql
CREATE TABLE BOOK
(
PrimaryAuthor CHAR(30),
Title CHAR(60),
ISBN CHAR(10),
PublisherID
www.eeworm.com/read/464911/7062655
sql createdb.sql
Part II:
1. CREATE TABLE BOOK
(
PriAut char(10),
Title char(30),
ISBN char(30),
PubID char(10),
Edition integer(4),
PubDate char(20),
Price
www.eeworm.com/read/440502/7068515
sql getcollegename.sql
CREATE OR REPLACE FUNCTION GET_COLLEGE_NAME (P_BH NUMBER)
RETURN VARCHAR2
AS
V_NAME VARCHAR2(30);
BEGIN
SELECT 院校名称 INTO V_NAME FROM COLLEGE WHERE 院校编号=P_BH;
RETURN (V_NAME
www.eeworm.com/read/440502/7068521
sql getscore.sql
CREATE OR REPLACE FUNCTION GET_SCORE (P_BH NUMBER)
RETURN NUMBER
AS
V_SCORE NUMBER(3);
BEGIN
SELECT 总分 INTO V_SCORE FROM SCORE WHERE 编号=P_BH;
RETURN (V_SCORE);
EXCEPTION
W