USE [SRO_R_Accountdb]
GO
/****** Object: StoredProcedure [dbo].[_CertifyUser] Script Date: 6/22/2016 9:49:15 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_CertifyUser]
@
[Only registered and activated users can see links. Click Here To Register...]serID varchar(25),
@
[Only registered and activated users can see links. Click Here To Register...]assword varchar(50),
@
[Only registered and activated users can see links. Click Here To Register...]SNumber varchar(32)
as
declare @
[Only registered and activated users can see links. Click Here To Register...]erJID int
declare @
[Only registered and activated users can see links. Click Here To Register...]primary tinyint
declare @
[Only registered and activated users can see links. Click Here To Register...]content tinyint
set @
[Only registered and activated users can see links. Click Here To Register...]erJID = 0
set @
[Only registered and activated users can see links. Click Here To Register...]primary = 0
set @
[Only registered and activated users can see links. Click Here To Register...]content = 0
if (not exists(select JID from TB_User where StrUserID = @
[Only registered and activated users can see links. Click Here To Register...]serID))
begin
select convert( int, 0), convert( tinyint, 0), convert( tinyint, 0)
return
end
select @
[Only registered and activated users can see links. Click Here To Register...]erJID = JID from TB_User where StrUserID = @
[Only registered and activated users can see links. Click Here To Register...]serID
if @
[Only registered and activated users can see links. Click Here To Register...]erJID = 0 or @
[Only registered and activated users can see links. Click Here To Register...]erJID is null or @@error <> 0 or @@rowcount = 0)
begin
select convert( int, 0), convert( tinyint, 0), convert( tinyint, 0)
return
end
if (not exists(select JID from TB_User where JID = @
[Only registered and activated users can see links. Click Here To Register...]erJID and password = @
[Only registered and activated users can see links. Click Here To Register...]assword))
begin
select convert( int, 0), convert( tinyint, 0), convert( tinyint, 0)
return
end
select @
[Only registered and activated users can see links. Click Here To Register...]primary = sec_primary, @
[Only registered and activated users can see links. Click Here To Register...]content = sec_content from TB_User with (nolock) where JID = @
[Only registered and activated users can see links. Click Here To Register...]erJID
select @
[Only registered and activated users can see links. Click Here To Register...]erJID, @
[Only registered and activated users can see links. Click Here To Register...]primary, @
[Only registered and activated users can see links. Click Here To Register...]content