0 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