Must declare the scalar variable - Error

[Shweta]

Hi All,

I have two tables "student" & "student_add" in SQL. I have created a procedure to update the address of a student. While executing the procedure I am getting an error : Must declare the scalar variable "@s_name".

Table: Student

Student_Name	Roll_No
Deepti	40
Priya	30
Shivya	50
Shweta	10
Yuvraj	20

<tbody>
</tbody>

Table: student_add

Roll_No	Stu_Address
10	Noida
20	Gurgaon
30	Ghaziabad
40	Delhi
50	Faridabad

<tbody>
</tbody>

Procedure:

Create proc Update_address
@Student_Name nvarchar(20),@Student_address nvarchar(20)
as
begin
update student_add
set Stu_Address = @Student_address
where Roll_No = (select Student_add.roll_no
                from student_add
                inner join student
                on student.roll_no = student_add.roll_no
                where student.student_name = @Student_Name)
end            

----Executing  the procedure



declare @s_name nvarchar(20) = 'Deepti'
declare @s_address nvarchar(20)='Gwalior'


execute update_address @s_name,@s_address ----prompting an error

[COLOR=#ff0000]Msg 137, Level 15, State 2, Line 2[/COLOR]
[COLOR=#ff0000]Must declare the scalar variable "@s_name".[/COLOR]

Instead of declaring the variables, if I pass the values(name and address) directly to the procedure like below, it works fine.

execute update_address 'Deepti','Gwalior'

Kindly suggest.

Thanks in advance!

Regards,
Shweta Jain

 

[james_lankford]

try putting a semi colon at the end of these two lines

declare @s_name nvarchar(20) = 'Deepti' ;
declare @s_address nvarchar(20)='Gwalior' ;

 

[xenou]

For what it's worth, works fine for me.

declare @s_name nvarchar(20) = 'Deepti'
declare @s_address nvarchar(20)='Gwalior'


execute update_address @s_name,@s_address ----prompting an error

 

[Shweta]

Thank you both!

Sorry for the delay in response.

I tried putting semicolon at the end but still it's not working. Please suggest.

 

[james_lankford]

this is a SQL Sever database ?

and are you using Access or Management Studio to do this ?

 

[Shweta]

I am using SQL server management studio.

 

[xenou]

How are you actually running this? the code you posted can't be right (are you selecting some of that text to execute it?) The code says the error is on line two but which is line 2 when you actually run it?