- ALTER PROCEDURE [dbo].[get_user]
-
(
-
@user_id varchar(8),
-
@pwd varchar(12)
-
)
-
AS
-
-
IF EXISTS(SELECT Personel_No From TblUser_ID where Personel_No = @user_id)
-
BEGIN
-
IF EXISTS(SELECT Password From TblUser_ID where Personel_No = @user_id AND Password = @pwd)
-
BEGIN
-
INSERT INTO TblAudit_Trails(Personel_No,IC_Baru,Business_Area)
-
SELECT Personel_No,IC_Baru,Business_Area
-
From TblPeribadi
-
WHERE Personel_No = @user_id AND IC_Baru = @pwd
-
RETURN(3)
-
END
-
ELSE
-
RETURN(1)
-
END
-
ELSE
-
BEGIN
-
IF EXISTS(SELECT Personel_No From TblPeribadi where Personel_No = @user_id)
-
BEGIN
-
IF EXISTS(SELECT IC_Baru From TblPeribadi where Personel_No = @user_id AND IC_Baru = @pwd)
-
BEGIN
-
INSERT INTO TblAudit_Trails(Personel_No,IC_Baru,Business_Area)
-
SELECT Personel_No,IC_Baru,Business_Area
-
From TblPeribadi
-
WHERE Personel_No = @user_id AND IC_Baru = @pwd
-
-
INSERT INTO TblUser_ID(Personel_No,Password,Update_By)
-
VALUES(@user_id,@pwd,@user_id)
-
RETURN(4)
-
END
-
ELSE
-
RETURN(2)
-
END
-
ELSE
-
RETURN(0)
-
END
-
//Msg 207, Level 16, State 1, Procedure get_user, Line 15
Invalid column name 'Personel_No'.
Msg 207, Level 16, State 1, Procedure get_user, Line 30
Invalid column name 'Personel_No'.
It appears as my thought cannot be double INSERT statement.but some example of SQL statement that I search for make it successful
So someone please help me..........