代码搜索：课堂设计
找到约 10,000 项符合「课堂设计」的源代码
代码结果 10,000
www.eeworm.com/read/346177/11763586
sql 课堂示范.sql
--以下是NULL/NOT NULL约束的例子
--====================================================================================================
--创建一个Customer表，包含三个列CustomerID、Pfirstname和Plastname三个列,且设CustomerID列不允
www.eeworm.com/read/346177/11763592
txt 课堂示范.txt
create proc zcc @zcc varchar(10)
as
select dbo.定单.运输价格+dbo.定单.包装价格+dbo.定单详情.玩具价格 as 总费用
from dbo.定单 inner j
www.eeworm.com/read/346177/11763608
txt 课堂案例.txt
-----1.创建数据库并将当前库切换为该库
create database sampledb
use sampledb
go
----创建数据库并将当前库切换为该库
create database sampledb
go
use sampledb
-------------------------------------------------------------
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/11763658
txt 课堂示范.txt
游标与自定义函数案例
一、课堂演示案例
例一：创建一个简单的游标
创建游标
declare TitleCursor CURSOR
scroll
for
select title_id,title,price,ytd_sales from titles
where type='psychology'
-----------------------------------------
www.eeworm.com/read/346177/11763662
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 employee
www.eeworm.com/read/130160/14204783
ppt 课堂讨论.ppt
www.eeworm.com/read/392266/8353614