HOW TO CREATE STORE PROCEDURE IN SQL SERVER 2008 WITH PARAMETER ?

          
           CREATE STORE PROCEDURE IN SQL SERVER 2008 WITH PARAMETER 


Create :

CREATE PROCEDURE  uspGetAddress @Name varchar(30)

AS

SELECT * 

FROM sushil.dbo.test

WHERE Name = @Name

GO

Execute :  

                                EXEC uspGetAddress a