Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
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?
on 11/30/2012 | Category:
Sql Server Interview questions
| Views: 2498 |
Select from following answers:
using Instead Of Triggers
Implmenting After Triggers (For Triggers)
Creating Stored Proceures
Creating User Defined functions
Trigger should be created. A trigger is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.
That too "After Trigger" should be created for "Transaction table". "After trigger" run after an insert, update or delete on a table.
As soon as modifcation made in Transaction table "After trigger" fired and should insert the row in Log table.
Instead Of Triggers used as interceptor for our table.If any one tries to modify our table which has instead of triggers, then instead of triggers will be fired.
Stored procedures are pre compiled statements for performing repetitive tasks
User-defined functions are routines that accept parameters, perform an action, such as a complex calculation, and return the result of that action as a value and table format.
Show Correct Answer
CTS Interview |
< Previous :
You want to remove the Odometer column of the Hove ...
Next > :
Write a C# sharp Program to check wheather the giv ...
Comments or Responses
Login to post response
More Interview Questions by Nagasundar_Tn
Write a C# sharp Program to check wheather the given string is Palindr ...
Which namespace will you use to get the value of connection string def ...
Write a C# program that prints the Prime numbers between 1 and 100 and ...
There is a PDF file which contains "GuideLines" in particul ...
Write a program in C# using Linq that prints count of leap years in 20 ...
What are the differnt categories of variables available in C#?
Write a code snippet that implements Virtual keyword ,overrides the vi ...
What are all the different types of User defined functions in sql serv ...
Latest Interview Questions
Explain how do you differentiate between design pattern and framework ...
What is a design Pattern?
What is software architecture?
Recently, systems administrators scaled a web application you designed ...
You recently deployed an ASP.NET web application. Although the applica ...
You are designing a web application that will be deployed across ten s ...
You are creating a view for an MVC application. You need to create a n ...