SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 746 Page Views: 

How many Logical tables are available in the triggers?



Posted By: Avi Date: 1 October 2010 12:29:08 PM
 Answer:

Whenever the triggers are used there exists two logical tables viz. Deleted table and Inserted table. Deleted Table contains all the rows which were updated or deleted during the trigger is processed. Inserted table hold the rows which were inserted or updated during the execution of the trigger.


Posted By: avibtech

Date: 1 October 2010 12:29:08 PM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image IMcX05
Related Questions
SQL Server : Which SQL Statement is used to show fragmentation information for data and indexes of the specified table?
SQL Server : When a table is create with a Primary Key, then what sort of integrity is maintained?

When a table is create with a Primary Key, then what sort of integrity is maintained?

Entity Integrity. As it defines the row as a unique entity for a particular table which is forced by....
Category: SQL Server Date: 10/1/2010 12:27:08 PM
SQL Server : Which clauses are not supported by VIEW Creation Statement?

Which clauses are not supported by VIEW Creation Statement?

While creating a VIEW one can not use ORDER By,COMPUTE BY,COMPUTE clauses. Also INTO Keyword and tem....
Category: SQL Server Date: 10/1/2010 12:26:08 PM
SQL Server : Point out some disadvantages of CURSORS?

Point out some disadvantages of CURSORS?

1. They Keep the network busy because of there roundtrip. 2. It is time consuming , so decreases th....
Category: SQL Server Date: 10/1/2010 12:25:08 PM
SQL Server : What do you mean by Heap Table?

What do you mean by Heap Table?

These are the tables without clustered Indexes and possses one row in sys.partitions with index_id=....
Category: SQL Server Date: 10/1/2010 12:23:08 PM
 
Signup for our weekly email newsletter
email newsletter
Questions Categories