Stored Procedures

Creating

CREATE PROCEDURE sp_GetRecord
@pro_num varchar(10)
AS
SELECT *
FROM DATA_DETAILS
WHERE pro_number = @pro_num

Executing

EXECUTE sp_GetRecord '16571565'