Santosh Kumar Adidawarpu
Why not we should prefix stored procedure names with “sp_”?
By Santosh Kumar Adidawarpu in SQL Server on Nov 16 2017
  • Santosh Kumar Adidawarpu
    Nov, 2017 16

    The prefix sp_ is reserved keyword for system stored procedures that ship with SQL Server. Whenever SQL Server encounters a procedure name starting with sp_, it first tries to locate the procedure in the master database and then it looks for any qualifiers (database, owner) provided and then it tries dbo as the owner. So you can really save time in locating the stored procedure by avoiding the sp_ prefix.

    • 3
  • Kapil Singh Kumawat
    Jun, 2018 26

    stored procedure starting sp_ indicates that these are system defined stored procedures

    • 1
  • Deepak Verma
    May, 2018 28

    Because it is a reserved keyword for system stored procedure.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS