Update command in SQL Stored procedure
Hi,I want to pass the parameter to Sql stored procedure to update the data. But i could not do this. could you please help me.
create proc std_data_updata
@Std_no varchar(10), @Std_name varchar(10), @Std_class varchar(10), @Std_city varchar(10),@Std_phone varchar(10), @Std_age int
as
update std_table set Std_no= @Std_no, Std_name=@Std_name, Std_class=@Std_class, Std_city=@Std_city, Std_phone=@Std_phone, Std_age=@Std_age where Std_name=@Std_name
how to pass the values. Stored procedure is executed successfully. But could not pass the value.
exec std_data_updata @Std_no='011', @Std_name='gopadfa',@Std_class='asp.net',@Std_city = 'aga', @Std_phone = '98745', @Std_age = 30 where @std_no = 001