Gert Lombard's Blog     About     Archive     Feed
My passion is code quality, automated testing, software craftsmanship.

Why do you prefix stored proc names with sp?

You don't call variable "x" in your C# code xVariable or var_x.

You don't call a table "Products" in your database ProductsTable or table_Products.

So why do you call your stored procedures sp_GetProducts?

Are prefixes really necessary in stored proc names? Isn't it obvious enough that it's a stored procedure?

Just wondering.

(If you have to prefix your stored procs, don't use "sp" because then they appear to be system stored procs...)