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

Can we use where clause in union?

1048


What the class forname () does?

1037


What is de-normalization and what are some of the examples of it?

958


Can you pass expressions to stored procedure parameters?

1013


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1661


What is bulkcopy in sql?

935


what is unique and xaml nonclustered index

1032


Explain the disadvantages of cursors?

1124


What are the three different part of rdl file explain them?

263


Explain the cursor lock types?

1030


What is implicit mode in sql server?

1076


How to run queries with sql server management studio express?

1072


What are the differences between substr and charindex in sql server.

1085


Find columns used in stored procedure?

974


Difference between group by clause and having clause in SQL?

957