SQL Server stored procedure - August 29, 2008 at 18:00 PM by
Nishant Kumar
Define Stored Procedures.
A stored procedure is a compiled set of Transact-SQL statements.
The business logic can be encapsulated using stored procedure.
It improves network traffic by running set of Transact-SQL statements at one
go.
Define extended Stored Procedures.
An extended stored procedure compiles as DLL and are created to expand
capabilties of user defined stored procedure. It uses xp_ prefix as naming
convention.
The answers to following questions will be made available soon. Keep
visiting.
Define Stored procedure.
What are the purposes and advantages stored procedure?
Determine when to use stored procedure to complete SQL Server tasks.
Explain the categories of stored procedure i.e. System stored procedure, local
stored procedure, temporary stored procedure, extended stored procedure, remote
stored procedure.
Explain nested stored procedure. Syntax and an example for create nested stored
procedure.
What security features are available for stored procedure?
In what three ways is the RETURN statement used in a stored procedure.
|