SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE dbo.StoredProcedure 
	-- Add the parameters for the stored procedure here
	@Param1 int = 0
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	
    -- Insert statements for procedure here
	SELECT @Param1;
END
sp_help StoredProcedure


Name
Owner
Type
Created_datetime


StoredProcedure
dbo
stored procedure
25/09/2018 10:42:16




Parameter_name
Type
Length
Prec
Scale
Param_order
Collation


@Param1
int
4
10
0
1
null


 
 