Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Which virtual table does a trigger use?

Answer Posted / yoshita

DML triggers use the deleted and inserted logical
(conceptual) tables. They are structurally similar to the
table on which the trigger is defined, that is, the table
on which the user action is tried. The deleted and inserted
tables hold the old values or new values of the rows that
may be changed by the user action. For example, to retrieve
all values in the deleted table, use

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of triggers in SQL SERVER?

1047


How to copy data from one table to another table?

927


How to add an address record into adventureworkslt?

931


If a stored procedure is taking a table data type, how it looks?

6339


What can be used instead of trigger?

1095


In what three ways is the return statement used in a stored procedure?

951


How do I delete a sql server database?

981


Name 3 ways to get an accurate count of the number of records in a table?

964


How to use user defined functions in expressions?

1005


How to select some specific rows from a table in ms sql server?

960


What are the general features of sql server management studio? : sql server management studio

1011


What is the use of RDBMS?

956


What is attribute? : sql server analysis services, ssas

977


How to encrypt data between dialogs?

1028


What is sql server profiler?

949