Sql Server自定义存储过程实例_sql用户自定义存储过程例子-优快云博客

本文链接：https://blog.youkuaiyun.com/ITFLY8/article/details/1946965

本文介绍了一个用于查询用户站点当前数据视图的过程。该过程可以根据指定的用户ID、站点ID及时间范围等条件来筛选数据，并能灵活地适应不同的查询需求。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

CREATE Procedure UserSiteNowDataView_List(
@UserID int,
@Type int,
@StartTime varchar(25),
@EndTime varchar(25),
@SiteID int
)
AS

--返回查询数据
declare @SQLString nvarchar(200)
declare @SQLTemp nvarchar(200)

set @SQLString=N'SELECT * FROM dbo. UserSiteNowDataView WHERE VisitTime between '''+@StartTime
set @SQLString=@SQLString+N''' and '''+@EndTime+''''

if @UserID!=0
set @SQLString=@SQLString+N' and UserID='+cast(@UserID as nvarchar)

if @SiteID!=0
set @SQLString=@SQLString+N' and SiteID='+cast(@SiteID as nvarchar)

exec sp_executesql @SQLString

--SELECT *
--FROM dbo. UserSiteNowDataView
--WHERE VisitTime between @StartTime and DateAdd(d,1,@EndTime) and SiteID=@SiteID Order by id desc

--返回当天数据
/*
if @Type=0
set @SQLString=n"SELECT *
FROM dbo. UserSiteNowDataView
WHERE (CONVERT(varchar(30), VisitTime, 10) = CONVERT(varchar(30), GETDATE(), 10)) "

--返回昨天数据
if @Type=1
set @SQLString=n"SELECT *
FROM dbo. UserSiteNowDataView
WHERE (CONVERT(varchar(30), VisitTime, 10) = CONVERT(varchar(30), DateADD(d,-1,GETDATE()), 10))"
--返回当月数据
if @Type=2
set @SQLString=n"SELECT *
FROM dbo. UserSiteNowDataView
WHERE id is not null"
*/