You have a Transaction table which is very important table because it contains all data of transacations that happend from beginning. You have a transaction log table.
If there is any modification done in transacations table automatically the old data for that row should be inserted in Transaction Log table. How will you achive this?

 Posted by Nagasundar_Tn on 11/30/2012 | Category: Sql Server Interview questions | Views: 2498 | Points: 40
Select from following answers:
  1. using Instead Of Triggers
  2. Implmenting After Triggers (For Triggers)
  3. Creating Stored Proceures
  4. Creating User Defined functions
  5. All Above

Show Correct Answer

Asked In: CTS Interview | Alert Moderator 

Comments or Responses

Login to post response