62,046
社区成员
发帖
与我相关
我的任务
分享
create proc sp_SGetUserInfo
(
@DateStart datetime,
@DateEnd datetime,
@KeyWord nvarchar(100)
)
as
select
*
from
table
where
(isnull(@DateStart,'')='' or CrDate>@DateStart)
and
(isnull(@DateEnd,'')='' or CrDate<@DateEnd)
and
(isnull(@KeyWord,'')='' or KeyWord=@KeyWord)