Avoid Naming User Stored Procedures SP% or SP_%

by

The reserved prefix that exhibits this behaviour is sp_. Not sp.

A stored procedure called spAddUser will be resolved in the normal way without looking for a matching object in master.

The relevant quote in books online is

Avoid the use of the sp_ prefix when naming procedures. This prefix is
used by SQL Server to designate system procedures. Using the prefix
can cause application code to break if there is a system procedure
with the same name.

But I would avoid these prefixes anyway. If all the stored procedures are prefixed sp it quickly gets annoying IMO.

More Related Contents:

  1. T-SQL stored procedure that accepts multiple Id values
  2. Select columns from result set of stored procedure
  3. Escape a string in SQL Server so that it is safe to use in LIKE expression
  4. Retrieve column definition for stored procedure result set
  5. Dapper.NET and stored proc with multiple result sets
  6. How to list all dates between two dates [duplicate]
  7. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  8. EXEC sp_executesql with multiple parameters
  9. T-SQL Dynamic SQL and Temp Tables
  10. How do I find a stored procedure containing ?
  11. How do I search an SQL Server database for a string?
  12. Calling an API from SQL Server stored procedure
  13. Handling date in SQL Server
  14. SQL Server history table – populate through SP or Trigger?
  15. Retrieve data from stored procedure which has multiple result sets
  16. Programmatically retrieve SQL Server stored procedure source that is identical to the source returned by the SQL Server Management Studio gui?
  17. Calling stored procedure using VBA
  18. Stored Procedure and Permissions – Is EXECUTE enough?
  19. Execute stored procedure with an Output parameter?
  20. OR Operator Short-circuit in SQL Server
  21. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  22. Stored procedure – return identity as output parameter or scalar
  23. Does query plan optimizer works well with joined/filtered table-valued functions?
  24. How to find a text inside SQL Server procedures / triggers?
  25. Python – pyodbc call stored procedure with parameter name
  26. SQL Server stored procedure return code oddity
  27. Why would using a temp table be faster than a nested query?
  28. How to cleanse (prevent SQL injection) dynamic SQL in SQL Server?
  29. ODBC Call Failed with stored procedure – Pass through query
  30. Why can’t Entity Framework see my Stored Procedure’s column information?

Leave a Comment