Thursday, April 17, 2008

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...)