How to create stored procedure with parameter in sql server database

Question

Hi How to create stored procedure with parameter in sql server 2008 ?

Arul Selvan · Answer

here i show for select paticular employee details based on id i passed id as a parameter like that you can pass parameter for stored procedure if you want to pass more than one parameter use  like @id INT@name varchar(20) CREATE PROCEDURE pro_GetEmployee @id INT AS BEGIN SELECT * FROM tbl_emp WHERE empid=@id END GO EXEC pro_GetEmployee 10001 Stored procedure parameter are to be two type IN and OUT the default is IN as we did earlier example not necessary to mention. The OUT parameter used for return value from stored procedure