I am new to sql server and learning store procedure i m creating store procedure for fetching data of perticuler ID as follow CREATE PROCEDURE SelectByID @ID INT AS BEGIN SELECT * FROM EmployeeDetails WHERE EmployeeID = @ID RETURN END GO; there is problem while execution Exec SelectByID ID = "4"; Please help me out it is showing error like "Incorrect Syntax near '=' ".

Hi Snehal Exec SelectByID 4 And Execute

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

hi ramesh sir still i am getting same error

Pass an Integer value Exec SelectByID ID = 4

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;