Hello friends,
I have used stored procedure to insert values in two tables
1.register
2.login
It is displaying errors...
Msg 207, Level 16, State 1, Procedure str_insert_register, Line 22<br />
Invalid column name 'adtsite'.<br />
Msg 207, Level 16, State 1, Procedure str_insert_register, Line 24<br />
Invalid column name 'emailid'.<br />
The Code Is:
CREATE PROCEDURE str_insert_register
@username nvarchar(50),
@firstname nvarchar(50),
@lastname nvarchar(50),
@fullname nvarchar(50),
@city nvarchar(50),
@street nvarchar(50),
@postcode nvarchar(50),
@telephone nvarchar(50),
@dob nvarchar(50),
@occupation nvarchar(50),
@emailid nvarchar(50),
@pwd nvarchar(50),
@abtsite nvarchar(50),
@entrydate datetime,
@activestatus int
AS
BEGIN
SET NOCOUNT ON
declare @id as int
SET @username=@firstname+right('0'+convert(varchar,datepart(dd,getdate())) ,2)
insert into register(id,username,firstname,lastname,fullname,city,street,postcode,telephone,dob,occupation,emailid,pwd,adtsite,entrydate,activestatus)values(@id,@username,@firstname,@lastname,@fullname,@city,@street,@postcode,@telephone,@dob,@occupation,@emailid,@pwd,@abtsite,@entrydate,@activestatus)
declare @stid as int
insert into login(stid,username,emailid,pwd)values(@stid,@username,@emailid,@pwd)
END
GO
Please check.
How can I resolve this error ?