Store Procedure with one parameter

Accepted answer

Hi Snehal

Exec SelectByID 4 And Execute

+2

Hi Snehal,

We need to execute store procedure with @ID = 4 or direct parameter value base on data type. you can try below two ways of executing procedure

Exec SelectByID @Id = 4
Exec SelectByID 4

0

snehal suryavanshi8y ago

hi ramesh sir

still i am getting same error

0

Sanwar Ranwa8y ago

Pass an Integer value

Exec SelectByID ID = 4

0

Ramesh Palanivel8y ago

Hi Snehal,

Your parameter is integer and you are trying to pass it as string. that is the problem you are getting error. And one more problem is In sql server string values needs to be mentioned inside single quotes, not double quotes. you are declared you string as double quotes.

Please execute like Exec SelectByID 4;

0