- 浏览: 52436 次
- 性别:
- 来自: 北京
文章分类
最新评论
create proc [dbo].[PhoneRec] (@haoma varchar(32),@ser varchar(16) output)
as
if @haoma='' and @ser=''
begin
select a.serverid,c.serverip,a.filename,b.callernumber,b.callednumber,b.createtime,b.releasetime
from dbo.AGENTRECFILE as a
inner join dbo.COLOG as b
on a.coid=b.coid
inner join dbo.DEVICECFG as c
on a.serverid=c.serverid
order by b.createtime asc
end
else if @haoma=''
begin
select a.serverid,c.serverip,a.filename,b.callernumber,b.callednumber,b.createtime,b.releasetime
from dbo.AGENTRECFILE as a
inner join dbo.COLOG as b
on a.coid=b.coid
inner join dbo.DEVICECFG as c
on c.serverid=@ser and a.serverid=c.serverid
order by b.createtime asc
end
else if @ser=''
begin
select a.serverid,c.serverip,a.filename,b.callernumber,b.callednumber,b.createtime,b.releasetime
from dbo.AGENTRECFILE as a
inner join dbo.COLOG as b
on a.coid=b.coid
inner join dbo.DEVICECFG as c
on a.serverid=c.serverid
where b.callernumber=@haoma or b.callednumber=@haoma
order by b.createtime asc
end
else
begin
select a.serverid,c.serverip,a.filename,b.callernumber,b.callednumber,b.createtime,b.releasetime
from dbo.AGENTRECFILE as a
inner join dbo.COLOG as b
on a.coid=b.coid
inner join dbo.DEVICECFG as c
on c.serverid=@ser and a.serverid=c.serverid
where b.callernumber=@haoma or b.callednumber=@haoma
order by b.createtime asc
end
drop proc PhoneRec
exec PhoneRec 'xxx','yyy'
inner join group by
select d.serverip,a.数量 from devicecfg as d
inner join (
select serverid, count(recordid) as 数量
from agentrecfile
where createtime >='2014-12-05 10:30:00'
and createtime <='2014-12-05 15:00:00'
group by serverid
)as a
on a.serverid = d.serverid
备份表
SELECT * INTO [备份表] FROM [源表]
select d.serverid,count(e.extensionnumber) as co,d.serverip,d.serverdesc ,count(e.extensionnumber) from devicecfg as d
inner join EXTENSIONCFG as e
on d.serverid = e.recserverid
GROUP BY d.serverid,d.serverip,d.serverdesc
order by d.serverid
as
if @haoma='' and @ser=''
begin
select a.serverid,c.serverip,a.filename,b.callernumber,b.callednumber,b.createtime,b.releasetime
from dbo.AGENTRECFILE as a
inner join dbo.COLOG as b
on a.coid=b.coid
inner join dbo.DEVICECFG as c
on a.serverid=c.serverid
order by b.createtime asc
end
else if @haoma=''
begin
select a.serverid,c.serverip,a.filename,b.callernumber,b.callednumber,b.createtime,b.releasetime
from dbo.AGENTRECFILE as a
inner join dbo.COLOG as b
on a.coid=b.coid
inner join dbo.DEVICECFG as c
on c.serverid=@ser and a.serverid=c.serverid
order by b.createtime asc
end
else if @ser=''
begin
select a.serverid,c.serverip,a.filename,b.callernumber,b.callednumber,b.createtime,b.releasetime
from dbo.AGENTRECFILE as a
inner join dbo.COLOG as b
on a.coid=b.coid
inner join dbo.DEVICECFG as c
on a.serverid=c.serverid
where b.callernumber=@haoma or b.callednumber=@haoma
order by b.createtime asc
end
else
begin
select a.serverid,c.serverip,a.filename,b.callernumber,b.callednumber,b.createtime,b.releasetime
from dbo.AGENTRECFILE as a
inner join dbo.COLOG as b
on a.coid=b.coid
inner join dbo.DEVICECFG as c
on c.serverid=@ser and a.serverid=c.serverid
where b.callernumber=@haoma or b.callednumber=@haoma
order by b.createtime asc
end
drop proc PhoneRec
exec PhoneRec 'xxx','yyy'
inner join group by
select d.serverip,a.数量 from devicecfg as d
inner join (
select serverid, count(recordid) as 数量
from agentrecfile
where createtime >='2014-12-05 10:30:00'
and createtime <='2014-12-05 15:00:00'
group by serverid
)as a
on a.serverid = d.serverid
备份表
SELECT * INTO [备份表] FROM [源表]
select d.serverid,count(e.extensionnumber) as co,d.serverip,d.serverdesc ,count(e.extensionnumber) from devicecfg as d
inner join EXTENSIONCFG as e
on d.serverid = e.recserverid
GROUP BY d.serverid,d.serverip,d.serverdesc
order by d.serverid
发表评论
-
CentOS7安装配置Zabbix3.4
2018-07-25 09:14 469mini安装CentOS7 && 基本配置 ... -
CentOS7安装gitlab+汉化
2018-07-20 16:20 790mini安装centos7 更新yum源 yum - ... -
CentOS7安装jira,confluence
2018-07-18 16:47 1567mini安装centos7 更新yum源 yum -y ... -
Grafana安装&基本配置
2018-01-04 11:26 984安装Grafana yum -y install fon ... -
CentOS7 npm+zabbix 安装配置
2017-12-28 10:52 422mini安装centos7 更新yum源 yum -y ... -
CentOS7 MFS 安装配置+说明
2017-09-28 14:06 909mini安装centos7 更新yum源 yum -y ... -
centos7 docker nginx tomcat 动静分离 负载均衡配置
2017-09-26 16:01 509mini安装centos7 64位 yum -y upda ... -
sql每天统计查询
2017-09-14 12:01 718select YEAR(createtime)年,MONTH( ... -
centos6.6 RHCS安装配置
2015-06-26 13:22 0需要用到的各组件功能: RHCS(Red Hat Cluste ... -
ansible安装配置
2015-06-24 14:29 6011) 准备环境 1. yum -y install gcc g ... -
linux下强制新用户首次登陆修改密码
2015-04-29 14:36 1491linux下强制新用户首次登陆修改密码 1. 使用userad ... -
linux下apache启动,httpd: apr_sockaddr_info_get() failed for
2015-02-28 13:24 352httpd: apr_sockaddr_info_get() ... -
更新yum源
2015-02-28 11:36 367CentOS更改yum源与更新系统 [1] 首先备份/etc ... -
lvs+keepalived
2015-02-11 11:55 461安装ipvsadmin yum install -y gcc ... -
nginx+keepalived
2015-02-11 11:48 651vi /etc/keepalived/keepalived.c ... -
haproxy+keepalived安装配置说明
2015-01-31 17:46 1205安装Keepalived yum install -y ... -
AVAYA基本命令
2014-10-21 17:23 674AVAYA常用命令集 (2007-05-1 ... -
nmap详解
2014-04-01 17:37 577进行ping扫描,打印出对 ... -
查找虚拟机所在宿主机
2014-04-01 17:36 1593查找对应的ip地址的mac地址 #show arp | inc ... -
mysql备份数据库
2013-11-02 12:33 517备份MySQL数据库的命令 mysqldump -hhostn ...
相关推荐
SqlServer存储过程的导出导入 近日在研究SQL的存储过程,这里我陆续将我在使用存储过程中碰到的问题及解决办法发布到网上,请各位大虾指正。 SqlServer存储过程的导出导入,网上相关资料特别少,经过摸索,这里写...
SQLserver存储过程异常处理
详细描述SqlServer存储过程,从认识、创建到原理和写法
主要介绍了SQLServer存储过程中事务的使用方法,简短的代码带大家更好的学习使用SQLServer存储过程中事务,感兴趣的小伙伴们可以参考一下
执行Sqlserver存储过程返回DataSet
详细介绍了SqlServer的存储过程调试方法,适合初学者及想深入研究的开发人员
亲测SqlServer存储过程解密工具(dbForge SQL Decryptor 3.1.24) 支持sql2000、2005、2008(R2)、2012、2014、2016、2017的存储过程的解密; 程序运行需要 .NET Framework 4.5.2 or higher installed
文档记录了SQL Server在存储运用时的语法,需要有一定的SQL语言学习基本,本文档只是做了梳理与总结,以便查看和识记。
SQLSERVER 存储过程 语法
SQLSERVER存储过程例子
SqlServer存储过程游标 ,一个例子
SQLServer存储过程在系统开发中的应用 SQLServer存储过程在系统开发中的应用
简单的学习例子 sqlserver 存储过程、函数的创建和使用 和 常用知识点
SQL Server数据库中直接调用Web Service,不需要通过前台调用
VB 调用 sql server 存储过程。文档
SQL SERVER 存储过程的操作与管理
SQL Server存储过程的命名标准,整理了sql中的一些存储过程
Delphi与SQL Server存储过程编程详解
SQL存储过程习题,SQL触发器习题,SQL习题,基础语法,与W3School类似,初学者学习使用。