ALTER PROCEDURE dbo.count_bar_total_suppliers /* ( @parameter1 int = 5, @parameter2 datatype OUTPUT ) */ AS SELECT count(*) from bar_suppliers