Summary
As a DBA, it is important that you understand how you can use stored procedures and cursors to simplify your daily and weekly routines. If you understand what you can and cannot do with stored procedures and cursors, you can be of great benefit to your organization. Following are some important points to remember about SQL Server stored procedures:
A stored procedure is a series of precompiled SQL statements and control-of-flow language statements.
Stored procedures are stored on SQL Server and execute on SQL Server.
A remote stored procedure is a stored procedure that is executed on a SQL Server different from your local SQL Server.
Stored procedures can have input and output parameters.
The only user command permission that can be granted ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition 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.
