这里说pr_expire附近有语法错误
*****
declare @resumeUpdate datetime
SELECT @resumeUpdate=pr_update FROM rc_per_resume WHERE u_id=@pUID -- AND (pr_expire>getdate())
if @resumeUpdate IS NOT NULL
BEGIN
set @result = -1
return
END
*****
*****
declare @resumeUpdate datetime
SELECT @resumeUpdate=pr_update FROM rc_per_resume WHERE u_id=@pUID -- AND (pr_expire>getdate())
if @resumeUpdate IS NOT NULL
BEGIN
set @result = -1
return
END
*****
SELECT @resumeUpdate=pr_update FROM rc_per_resume
WHERE u_id=@pUID AND (pr_expire>getdate()) if @resumeUpdate IS NOT NULL
BEGIN
set @result = -1
return
END