代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/346177/11763507
sql 作业讲解.sql
--创建名为proc price_pro，功能：返回用户指定类图书的数量及其平均价格，默认为“business”类图书
create proc price_pro (@count int output,
@avgpri money output,
@type varchar(30)='business
www.eeworm.com/read/346177/11763552
sql 课堂演示.sql
--HAVING与WHERE的区别
--查询得到本年度截止到目前的销售额超过 $40,000 的出版商
SELECT pub_id,SUM(ytd_sales) as total
FROM titles
GROUP BY pub_id
where SUM(ytd_sales) > 40000
SELECT pub_id,SUM(ytd_sales) as total
FR
www.eeworm.com/read/346177/11763561
sql 课堂演示.sql
--HAVING与WHERE的区别
--查询得到本年度截止到目前的销售额超过 $40,000 的出版商
SELECT pub_id,SUM(ytd_sales) as total
FROM titles
GROUP BY pub_id
where SUM(ytd_sales) > 40000
SELECT pub_id,SUM(ytd_sales) as total
FROM t
www.eeworm.com/read/346177/11763586
sql 课堂示范.sql
--以下是NULL/NOT NULL约束的例子
--====================================================================================================
--创建一个Customer表，包含三个列CustomerID、Pfirstname和Plastname三个列,且设CustomerID列不允
www.eeworm.com/read/346177/11763617
sql 课堂演示.sql
select j.EmployeeID,i.ReportsTo
from dbo.Employees i inner join dbo.Employees j
on i.EmployeeID = j.EmployeeID
GO
--交叉联结举例
--先创建一个示例库备用
create database test
go
--使用示例库
use test
go
--在
www.eeworm.com/read/346177/11763623
sql 课堂示范.sql
--以下是NULL/NOT NULL约束的例子
--====================================================================================================
--创建一个Customer表，包含三个列CustomerID、Pfirstname和Plastname三个列,且设CustomerI
www.eeworm.com/read/346177/11763645
sql 课堂演示.sql
select j.EmployeeID,i.ReportsTo
from dbo.Employees i inner join dbo.Employees j
on i.EmployeeID = j.EmployeeID
GO
--交叉联结举例
--先创建一个示例库备用
create database test
go
--使用示例库
use test
go
--在示例库中创建
www.eeworm.com/read/346177/11763679
sql createrecruitmentdb.sql
/* Install Recruitment database */
USE master
if exists (select * from sysdatabases where name='Recruitment')
begin
DROP database Recruitment
end
GO
create DATABASE Recr
www.eeworm.com/read/346177/11763681
sql createglobaltoyzdb.sql
/* Install GlobalToyz database */
USE master
if exists (select * from sysdatabases where name='GlobalToyz')
begin
DROP database GlobalToyz
end
GO
CREATE DATABASE Globa
www.eeworm.com/read/346177/11763686
sql createglobaltoyzobjectswithoutconstraints.sql
USE GlobalToyz
go
/* creating required data types */
execute sp_addtype id ,'char(6)' ,'NOT NULL'
Go
create table 类别
(
类别号 char(3),
类别名 char(20),
描述号 varchar(100)
)
insert into 类别