|
What are Global and
Local cursors?
SQL Server cursors - August 29, 2008 at 18:00 PM by Amit Satpute
What are Global and Local cursors?
Local cursors are available only in the batch, stored procedure, or trigger in
which they were created. They are implicitly deallocated when the batch, stored
procedure, or trigger terminates.
Global cursors are global to the connection.They are implicitly deallocated at
disconnect.
Also read
Answer - Data Integrity validates the data before getting
stored in the columns of the table. SQL Server supports four type of data
integrity.....
Answer - Distributed Query is a query which can retrieve data
from multiple data sources including distributed data........
Answer - Temporary Stored Procedure is stored in TempDB
database. It is volatile and is deleted once connection gets terminated or
server is restarted......
Answer - The column or columns of the table whose value
uniquely identifies each row in the table is called primary key. You can define
column as primary key using primary key constraint while you create table.....
Answer - Index can be thought as index of the book that is used
for fast retrieval of information. Index uses one or more column index keys and
pointers to the record to locate record.........
|
