php教程|PHP开发
SQL存储过程
php教程-PHP开发
set ANSI_NULLS ON
php进销存v1源码,ubuntu联网驱动下载,使用爬虫抢票,php chttp,seo年薪百万lzw
set QUOTED_IDENTIFIER ON
外卖源码出售,vscode获取远程进程id,ubuntu读写ntfs,tomcat内存设置位置,爬虫就是小偷,php 自定义设置,龙岗深企在线seo优化,分类查询网站源码,购物车 网页模板lzw
go
祭祀 网站源码,vscode多人协作,ubuntu运用,tomcat 重启很慢,移植sqlite3,js三级联动日期选择插件,从零开始写前端框架,网络爬虫对科研帮助,php连接odbc,郑州seo设计代理,国外好看的教育类网站模板下载,html 播放视频的网页,动漫介绍网页模板免费下载lzw
— =============================================
— Author:wgh
— Create date: -06-07
— Description: IP访问预统计
— =============================================
CREATE PROCEDURE [dbo].[PROC_HB_PreStatByIP]
@BeginTime varchar(50),
@EndTime varchar(50),
@TimeType int, –0代表小时 、 1代表天
@ChannelID varchar(10)=’0′,
@IpAddress varchar(20)
AS
BEGIN
declare @sql1 nvarchar(2000)
IF @TimeType = 0
BEGIN
SET @sql1=’SELECT CONVERT(varchar(13),AddTime,120) AS ”日期”
,ChannelID AS ”推广渠道”
,IPAddress AS ”IP地址”
,ViewCount AS ”浏览次数”
,ClickCount AS ”点击次数”
FROM dbo.HB_AdPreStatIP WHERE AddTime>=”’+@BeginTime+”’ AND AddTime<=\+@EndTIme+\\
IF @ChannelID ‘0’
BEGIN
SET @sql1 =@sql1 + ‘ AND ChannelID=”’+@ChannelID+””
END
IF @IpAddress ”
BEGIN
SET @sql1 =@sql1 +’ AND IPAddress=”’+@IpAddress+””
END
SET @sql1 =@sql1+’ ORDER BY ViewCount DESC’
END
ELSE
BEGIN
SET @sql1=’SELECT CONVERT(varchar(10),AddTime,120) AS ”日期”
,ChannelID AS ”推广渠道”
,IPAddress AS ”IP地址”
,SUM(ViewCount) AS ”浏览次数”
,SUM(ClickCount) AS ”点击次数”
FROM dbo.HB_AdPreStatIP WHERE AddTime>=”’+@BeginTime+”’ AND AddTime<=\+@EndTIme+\\
IF @ChannelID > ‘0’
BEGIN
SET @sql1 =@sql1 + ‘ AND ChannelID=”’+@ChannelID+””
END
IF @IpAddress ”
BEGIN
SET @sql1 =@sql1 +’ AND IPAddress=”’+@IpAddress+””
END
SET @sql1 =@sql1 + ‘GROUP BY CONVERT(varchar(10),AddTime,120),ChannelID,IPAddress ORDER BY SUM(ViewCount) DESC’
END
EXEC sp_executesql @sql1
END
