plzz tell me i want save the entry of registration module username field in another new table(test) so i cheeck the nuke database save the registration module entry by ADDuser store procedure . then :
set
ANSI_NULLS ON QUOTED_IDENTIFIER ON
GO
ALTER
@PortalID
PROCEDURE [dbo].[AddUser]int,
@Username
nvarchar(100),
@FirstName
nvarchar(50),
@LastName
nvarchar(50),
@AffiliateId
int,
@IsSuperUser
bit,
@Email
nvarchar(256),
@DisplayName
nvarchar(100),
@UpdatePassword
bit,
@Authorised
AS
DECLARE
SELECT
bit @UserID int @UserID = UserIDFROM dbo.UsersWHERE Username = @Username
IF
@UserID is null
BEGIN
INSERT INTO dbo.Users (
Username
,
FirstName
LastName
AffiliateId
, , ,
IsSuperUser
,
Email
,
DisplayName
,
UpdatePassword
)
VALUES (
@Username
,
@FirstName
@LastName
@AffiliateId
, , ,
@IsSuperUser
,
@Email
,
@DisplayName
,
@UpdatePassword
)
INSERT
INTO dbo.test (
Username
)
VALUES (
@Username
)
SELECT @UserID = SCOPE_IDENTITY()
IF
END @IsSuperUser = 0BEGIN
IF not exists ( SELECT 1 FROM dbo.UserPortals WHERE UserID = @UserID AND PortalID = @PortalID )
BEGIN
INSERT INTO dbo.UserPortals (
UserID
,
PortalID
,
Authorised
)
VALUES (
@UserID
,
@PortalID
,
@Authorised
)
END
SELECT
but
END @UserID
store procedure executed sucessffuly but in registration time give the error .plzz help me
set