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 distributed partitioned views?

1081


What is a DBMS, query, SQL?

1050


How to convert a table data in XML format in sql server?

2545


What is user defined stored procedures?

949


Is sql server 2016 free?

945


How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169


Tell me in brief how sql server enhances scalability of the database system?

994


What is data set in report?

137


How do you use a subquery to find records that exist in one table and do not exist in another?

1051


Comment,Datatypes are unlimited

2065


Explain the different index configurations a table can have?

948


what is the system function to get the current user's user id? : Sql server database administration

1027


Explain how many types of relationship?

1032


What is the difference between resultset and resultsetmetadata?

976


What is the use of stored procedure?

943