Stored Procedures
Some people start their stored procedures with sp. That's a no no. SQL Server looks for "sp_" when looking for certain objects. To avoid name collisions, begin your stored procedures with "usp_".
Stored procedures are named according to their function in the pipeline.
Last updated