Determine how to use the inserted and deleted pseudo tables?
Submitted by: AdministratorInserted and deleted pseudo tables contain the New and Old values of the data that initiating the Trigger. These tables can be used for database maintenance and dynamic modification to data. These tables can be examined by the trigger itself. The tables themselves cannot be altered.
Submitted by: Administrator
Submitted by: Administrator
Read Online SQL Server Triggers Job Interview Questions And Answers
Top SQL Server Triggers Questions
| ☺ | Explain trigger classes i.e. instead of and after trigger? |
| ☺ | Explain Syntax for viewing, dropping and disabling triggers? |
| ☺ | What are the instances when triggers are appropriate? |
| ☺ | Explain triggers? |
| ☺ | How to invoke a trigger on demand? |
Top New MS SQL Server Categories
| ☺ | SQL Server Database Administrator Interview Questions. |
| ☺ | SQL Server Service Broker Interview Questions. |
| ☺ | SQL Server Locks Interview Questions. |
| ☺ | SQL Server Constraints Interview Questions. |
| ☺ | MS SQL Data Mining Interview Questions. |
