ALTER PROCEDURE dbo.update_data
@user_id numeric(18,0),
@name1 varchar(50),
@address varchar(50),
@mob varchar(50),
@city varchar(50),
@emailid varchar(50),
@username varchar(50),
@password varchar(50),
@log_id numeric(18,0)
AS
BEGIN
Begin Transaction
begin
UPDATE [user.]
SET name1 = @name1,
address = @address,
mob = @mob,
city = @city,
emailid = @emailid
WHERE (user_id = @user_id)
SELECT log_id
FROM [user.]
WHERE (user_id = @user_id)
end
begin
UPDATE login
SET username = @username, password = @password
WHERE (log_id = @log_id)
end
Commit transaction
end
i have two table.1)profile :
name
address
city
mob
emailid
log_id
2)login:
log_id
username
password
i have to update data in profile and then select log_id from that updated data.
using this log_id i have to update login table.
for this i have write store procedure as given.but error comming like :storeprocedure expect parameter @log_id
what is problem in my code?