Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
To identify records that were updated in a table from a trigger,which of the following tables need to be checked?
on 7/1/2014 | Category:
Sql Server Interview questions
| Views: 638 |
Select from following answers:
Inserted system table
Updated system table
Deleted system table
Both Inserted and Deleted system table
The inserted system table and deleted system table,also known as the magic tables,are used by triggers to place inserted,updated or deleted records in a table.For insert,inserted table is used.For delete,deleted system table will be used.For update,the old values are contained in the inserted system table while the new values are contained in the deleted system table.
Show Correct Answer
Many Interviews |
< Previous :
Is there any updated system table in DB tables?
Next > :
Which of the following is the correct way to renam ...
Comments or Responses
Login to post response
More Interview Questions by vishalneeraj-24503
Which of the following is the correct way to rename a user database?
What will be the output of below IsNumeric functions? Select ISNUME ...
What are the other valid data types IsNumeric function supports?
What is the return type of IsNumeric function?
What will be the output of below statement? Select IsNumeric('1 ...
What is the use IsNumeric function?
What will be the value of the @Bit variable in below statement? dec ...
What will be the result? select STR(938.56,6,1);
Latest Interview Questions
You want to modify the server settings without using the Server proper ...
The RESTORE DATABASE T-SQL command can be used to restore a database. ...
When you uninstall SQL 2008, you will find that certain files are not ...
Which of the following built-in tool will allow you to change services ...
What is wrong with this CREATE LOGIN statement? CREATE LOGIN users ...
SQL Server Agent is commonly used to schedule work to be done automati ...
Which of the following system database records all the system-level in ...
SQL Server Agent can be used to run and schedule jobs that perform one ...