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
