must declare a scalar variable error will occur.

Question

hi i create a stored procedure in sql with in this i perform the insert operation in the insert command line must declare a scalar variable error will occur in one field how can i solve this Thank you

Krishna Garad · Answer

use like this Create Procedure registrations ( @mail varchar(100) @password varchar(50) @currpassword varchar(50) @mobno nchar(50) @dob varchar(100) @gender varchar(100) @currentlocation varchar(100) @address varchar(300) @experience varchar(10) @preferlocation varchar(100) @functionalarea varchar(300) @currentrole varchar(300) @areaofspecific varchar(300) @ugcourse varchar(200) @ugspecify varchar(200) @uginstitute varchar(300) @ugyop varchar(50) @pgcourse varchar(200) @pgspecify varchar(200) @pginstitute varchar(300) @pgyop varchar(50) @resume varbinary(max) ) As Begin Insert Into register(emailidpasswordcpasswordmobiledobgendercurrentlocationaddressexperincepreferlocationfunctionalrolecurrentroleareaofspecificugcourseugspecifyuginstituteugyoppgcoursepgspecifypginstitutepgyopresume) Values(@mail@password@currpassword@mobno@dob@gender@currentlocation@address@experience@preferlocation@functionalarea@currentrole@areaofspecific@ugcourse@ugspecify@uginstitute@ugyop@pgcourse@pgspecify@pginstitute@pgyop@resume) End

krithika muthukrishnan · Answer

hi in this source code i have 2 errorspls tell me what the error will occuri'll try to resolve it. Create Procedure registrations {//Incorrrect syntax near {(error will occur) @mail varchar ( 100 ) @password varchar ( 50 ) @currpassword varchar ( 50 ) @mobno nchar ( 50 ) @dob varchar ( 100 ) @gender varchar ( 100 ) @currentlocation varchar ( 100 ) @address varchar ( 300 ) @experience varchar ( 10 ) @preferlocation varchar ( 100 ) @functionalarea varchar ( 300 ) @currentrole varchar ( 300 ) @areaofspecific varchar ( 300 ) @ugcourse varchar ( 200 ) @ugspecify varchar ( 200 ) @uginstitute varchar ( 300 ) @ugyop varchar ( 50 ) @pgcourse varchar ( 200 ) @pgspecify varchar ( 200 ) @pginstitute varchar ( 300 ) @pgyop varchar ( 50 ) @resume varbinary ( max ) } As Begin Insert Into register ( emailid  password  cpassword  mobile  dob  gender  currentlocation  address  experince  preferlocation  functionalrole  currentrole  areaofspecific  ugcourse  ugspecify  uginstitute  ugyop  pgcourse  pgspecify  pginstitute  pgyop  resume ) Values ( @mail  @password  @currpassword  @mobno  @dob  @gender  @currentlocation  @address  @experience  @preferlocation  @functionalarea  @currentrole  @areaofspecific  @ugcourse  @ugspecify  @uginstitute  @ugyop  @pgcourse  @pgspecify  @pginstitute  @pgyop  @resume ) //must declare the scalar variable @mail error will occur. End

Koteswararao Mallisetti · Answer

that means with out declaring a variable you use that into stored procedure directly so it tells to is please declare that variable please make sure that all variables must be declare before use .

Shankey · Answer

hi Plz post your code also it will help us to get the error.