Tuesday, June 10, 2014

MSSQL - Optional parameter for procedure

ALTER PROCEDURE [dbo].[MyProcName]
    @Parameter1 INT = 1,
    @Parameter2 VARCHAR (100) = 'StringValue',
    @Parameter3 VARCHAR (100) = NULL
AS
begin
      select @Parameter1,@Parameter2,@Parameter3
end


No comments:

Post a Comment