Best practice to create stored procedure with template parameters in SQL Server

Every developers need to deal with stored procedures in daily life through SQL Server and need to follow different patterns to put signature and format to consistence structure of sps.

I have seen that many developers who start to create sp with New Query -> Create Stored procedure and then try to format the sp and put signature.

Instead we can use following best practice to create stored procedure in SQL Server



1) Go to Stored procedure tab and click New Stored Procedure

2) Press CTRL + SHIFT + M and it will prompt template to enter parameters information



3) Enter respective information and click OK  and it will apply format & signature accordingly so your stored procedure remain consistent in format & signature wise


cheers..