Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)

Team-Fly    

 
Sams Teach Yourself SQL in 24 Hours, Third Edition

By Ronald R. Plew, Ryan K. Stephens

Table of Contents
Hour 22.  Advanced SQL Topics

Q&A

Q1:

Can a stored procedure call another stored procedure?

A1:

Yes. The stored procedure being called is referred to as being nested.

Q2:

How do I execute a cursor?

A2:

Simply use the OPEN CURSOR statement. This sends the results of the cursor to a staging area.


Team-Fly    
Top
 

Категории