Cursors can be considers as named result sets which allow a user to move through each record one by one. SQL Server 2000 provides different types of cursors to support different type of scrolling options.
Showing posts with label Cursors. Show all posts
Showing posts with label Cursors. Show all posts
Using SQL Data Definition Language (DDL) to Create Data Tables and Other Database Objects
Using the CREATE TABLE Statement to Create Tables
Tables are the primary structures used to hold data in a
relational database. In a typical multi-user environment, the database
administrator (dba) creates the tables that serve as the data stores for the organization's data. Users normally create
their own temporary tables used to store data extracted from the main
organizational tables.
Benefits of Stored Procedures
| Benefit | Explanation of benefit |
|---|---|
| Modular programming | You can write a stored procedure once, then call it from multiple places in your application. |
Subscribe to:
Posts (Atom)