SQL: Create Stored Procedure

CREATE PROCEDURE procedureName
     @var1 INT,
     @var2 VARCHAR(255)
AS
BEGIN
     SELECT * FROM tablename WHERE fieldname = @var1
END

Leave a Reply

You must be logged in to post a comment.