Function Return Table
来源:互联网 发布:linux远程连接oracle 编辑:程序博客网 时间:2024/05/01 23:36
--Function Return Table
create function f_cid(
@ClassName varchar(10) --要查询的类别名(如果类别名会重复,改用NClassID
)returns @re table(NClassID int,level int)
as
begin
declare @l int
set @l=0
insert @re select NClassID,@l
from Class
where ClassName=@ClassName
while @@rowcount>0
begin
set @l=@l+1
insert @re select a.NClassID,@l
from Class a,@re b
where a.ClassID=b.NClassID and b.level=@l-1
end
return
end
go
--调用函数实现查询
select a.* ,b.ArticleID,b.Title
from Class a,Article b,f_cid('体育') a1 --查询体育及下面的所有子类
where a.NClassID=a1.NClassID and b.NClassID=a1.NClassID
and b.ArticleID in( select top 10 ArticleID from Article
where NClassID=a1.NClassID)
- Function Return Table
- JavaScript function return function..
- JS Function中的return
- The function return
- return alert from function
- return this.each(function(){})
- function 中return方法
- break,continue,return in function
- syntaxerror: 'return' outside function 解决办法
- python:'return' outside function 错误
- Oracle Table Function
- PLSQL Table Function
- PLSQL Table Function NO_DATA_NEEDED
- function should return a value; 'void' return type assumed
- return confirm Cannot return from outside a function or method
- x86 function call and return --- stack save the return address.
- Function Table 函数指针表
- __index = function (table, key)
- 在TOMCAT中部署war
- Unicode 问答集
- 在C#中使用ADO.Net部件来访问Access数据库
- openlaszlo内操作xml
- DEBUG全过程跟踪!
- Function Return Table
- Exists
- 二级dropdown弹出菜单(div+css)
- ExtendedSP
- MM图收 升级至V1.2.0.0
- count(distinct)
- 字符串类型如何转换成日期类型
- aes_cursor
- aes_cursor01