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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What are the two virtual tables SQL Server maintains for
triggers?

Question Posted / sri

Answer Posted / sri

The 2 virtual tables are the OLD and the NEW

OLD is invalid in the case of INSERT and NEW is invalid in
the case of DELETE statements

Inside the trigger we can use the OLD and NEW as follows

:OLD.columnname
:NEW.columnname

Is This Answer Correct ?    3 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to find the version of sql server? : sql server database administration

1045

Benefits of Stored Procedures?

918

Does partitioning help performance?

888

What is the beast way to write CTE in SQL Server ?

981

What are alternate keys?

934

How to rebuild master databse?

1029

What do we have to check in database testing?

967

Name some of the open source software that you can use in alternative to SSR?

151

What is microsoft sql server?

912

Can you pass expressions to stored procedure parameters?

970

What is an sql server agent?

995

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1008

what is an index? : Sql server database administration

931

What is change data capture (cdc) in sql server 2008?

979

What is the difference between insensitive and scroll cursor?

1070