Types of Stored Procedures
In SQL Server, there are four types of stored procedures: system stored procedures, user-defined stored procedures, temporary stored procedures, and extended stored procedures. System and extended stored procedures are created automatically at installation time. The other types (user-defined, temporary) are the ones users create explicitly.
System Stored Procedures
System stored procedures are created automatically in system databases when you install SQL Server. They are basically a way to interact with system tables. Moreover, there is a system stored procedure for almost any administrative task you perform in SQL server. Also, because Microsoft doesn't recommend dealing directly with system tables, this is the preferred ...
Get Microsoft® SQL Server™ 2000 Programming by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
