函数和游标
来源:互联网 发布:人工智能 国家政策 编辑:程序博客网 时间:2024/05/17 04:31
if exists(select 1 from sysobjects where id=object_id('St_FunPostDayTimeout'))
drop Function St_FunPostDayTimeout
go
Create Function St_FunPostDayTimeout()
returns varchar(2000)
as
begin
declare MyCursor cursor
for (select distinct count(budid) countBudid ,budid,budname from vw_WorkOrdWarning a inner join house b on a.WOID=b.id where
EWholeTime<getdate() and WorkOrdState='WOSta_TimeoutUnfinished' group by budid,budname)
open MyCursor
declare @countBudid varchar(2000),@budid varchar(20),@budname varchar(20),@Info varchar(2000),@sumCountPost int
set @sumCountPost=0
set @Info='分别('
fetch next from MyCursor into @countBudid,@budid,@budname
while (@@fetch_status=0)
begin
set @sumCountPost=@sumCountPost+@countBudid
set @Info=@Info+@budname+@countBudid+'件、'
fetch next from MyCursor into @countBudid,@budid,@budname
end
close MyCursor
deallocate MyCursor
set @Info='本日超期事件'+convert(varchar(1000),@sumCountPost)+'件'+substring(@Info,1,len(@Info)-1)+');'
return @Info
end
go
drop Function St_FunPostDayTimeout
go
Create Function St_FunPostDayTimeout()
returns varchar(2000)
as
begin
declare MyCursor cursor
for (select distinct count(budid) countBudid ,budid,budname from vw_WorkOrdWarning a inner join house b on a.WOID=b.id where
EWholeTime<getdate() and WorkOrdState='WOSta_TimeoutUnfinished' group by budid,budname)
open MyCursor
declare @countBudid varchar(2000),@budid varchar(20),@budname varchar(20),@Info varchar(2000),@sumCountPost int
set @sumCountPost=0
set @Info='分别('
fetch next from MyCursor into @countBudid,@budid,@budname
while (@@fetch_status=0)
begin
set @sumCountPost=@sumCountPost+@countBudid
set @Info=@Info+@budname+@countBudid+'件、'
fetch next from MyCursor into @countBudid,@budid,@budname
end
close MyCursor
deallocate MyCursor
set @Info='本日超期事件'+convert(varchar(1000),@sumCountPost)+'件'+substring(@Info,1,len(@Info)-1)+');'
return @Info
end
go
- 函数和游标
- Oracle中的游标和函数
- oracle 行转列(用函数和游标完成)
- 游标函数
- 中自定义函数和游标应用的经典案例
- MySQL存储过程和函数以及游标使用详解
- SQLserver用游标实现循环 和 简单的量值函数
- sql 语句拼接 游标遍历和函数遍历
- oracle中的游标,例外,存储过程,存储函数和触发器
- 静态游标和动态游标
- mysql游标和嵌套游标
- 静态游标和动态游标
- 声明和打开游标+游标+声明游标+打开游标
- 游标、过程、函数、包
- 存储过程、函数、游标 .
- 五.函数与游标
- mysql函数游标
- sqlserver 函数游标
- 对韦东山老师移植最新uboot的总结
- finally小特性
- 【mysql】关于切分查询
- Lua程序设计笔记之六: C API的使用
- 题目1069:查找学生信息
- 函数和游标
- 开机挂载硬盘
- Android编译相关知识
- 来写下我在这里的第一篇博文
- maven 配置在eclipse中
- poj 2528
- Lua程序设计笔记之七: lua与c互调
- TDD表达式再次实现(待完善)
- ubuntu tftp