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

What is a filestream?

1043

What are the difference between primary keys and foreign keys?

1010

How many tables can be joined in SQL Server?

1111

What is temporal data type?

963

Explain triggers in sql?

1001

What is the difference between ddl,dml and dcl commands?

1153

Can we hide the definition of a stored procedure from a use?

1296

Disadvantages of the indexes?

1182

What is hot add cpu in sql server 2008?

981

Why de-normalization required?

1053

How to download and install sql server 2005 books online?

1270

How do you manipulate data?

948

What is the use of stored procedure?

978

How to move database physical files in ms sql server?

1093

Can we call future method from queueable?

1097