代码搜索：课堂设计
找到约 10,000 项符合「课堂设计」的源代码
代码结果 10,000
www.eeworm.com/read/186767/8911515
doc 课堂习题.doc
www.eeworm.com/read/382823/8996544
doc 课堂考试.doc
www.eeworm.com/read/481493/6641800
jar 夫妻课堂.jar
www.eeworm.com/read/346177/11763471
txt 课堂案例.txt
视图与索引案例
----创建一个简单的视图
use pubs
go
---创建视图
create view titles_view
as
select title_id,title,type,price
from titles
----视图定义好后，就可以象普通表格一样使用
select * from titles_view
go
select title
www.eeworm.com/read/346177/11763475
txt 课堂示范.txt
-----1.用户自定义的标量函数的应用
Create Function tiji(@CubeLength decimal(4,1),@CubeWidth decimal(4,1),
@CubeHeight decimal(4,1))
Returns decimal(12,3)
As
Begin
Return (@CubeLength*@CubeWidth*@CubeHeight)
www.eeworm.com/read/346177/11763488
txt 课堂案例.txt
use pubs
go
--将所有的作者姓名都作为大写输出
select upper((au_fname+'.'+au_lname)) as 作者姓名 from authors
--将员工编号为PMA开头的员工编号显示为以PLM开头
select stuff(emp_id,1,3,'PLM') as new_empid,fname,lname,job_id
from employ
www.eeworm.com/read/346177/11763501
txt 课堂示范.txt
游标与自定义函数案例
一、课堂演示案例
例一：创建一个简单的游标
创建游标
declare TitleCursor CURSOR
scroll
for
select title_id,title,price,ytd_sales from titles
where type='psychology'
-----------------------------------------
www.eeworm.com/read/346177/11763531
txt 课堂案例.txt
----1.创建数据库并将当前库切换为该库
create database sampledb
use sampledb
go
----创建数据库并将当前库切换为该库
create database sampledb
go
use sampledb
----2. 修改表并引用新列
----先创建表备用
create table student
(
stu_id int pr
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