set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[GetUserManager]
@begintime datetime,
@endtime datetime,
@userinput varchar(200)
AS
BEGIN
select u.username,
u.nick,
ue.email,
ue.CheckEmail,
u.RegeditDatetime,
u.status,
u.LastLoginIP
from userinfo u
join userextinfo ue
on u.userid = ue.userid
where u.RegeditDatetime >= @begintime
and u.RegeditDatetime <= @endtime
and (u.username like '%@userinput%' or u.nick like '%@userinput%')END
我把里面的SQL 拿出来单独查可以 房在存储过程里面就不行了 求助那位好心大侠 给解释一下为什么
set QUOTED_IDENTIFIER ON
go-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[GetUserManager]
@begintime datetime,
@endtime datetime,
@userinput varchar(200)
AS
BEGIN
select u.username,
u.nick,
ue.email,
ue.CheckEmail,
u.RegeditDatetime,
u.status,
u.LastLoginIP
from userinfo u
join userextinfo ue
on u.userid = ue.userid
where u.RegeditDatetime >= @begintime
and u.RegeditDatetime <= @endtime
and (u.username like '%@userinput%' or u.nick like '%@userinput%')END
我把里面的SQL 拿出来单独查可以 房在存储过程里面就不行了 求助那位好心大侠 给解释一下为什么
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货