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
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Krishna GaradPosted Jan 31, 2011, 1:53 AM
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(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)
End
krithika muthukrishnanPosted Jan 31, 2011, 1:34 AM
in this source code i have 2 errors,pls tell me what the error will occur,i'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 MallisettiPosted Jan 31, 2011, 1:30 AM
ShankeyPosted Jan 31, 2011, 1:27 AM
Plz post your code also, it will help us to get the error.