Answer Posted / kmbkrishnan
Triggers use magic tables - Inserted and Deleted
updated or update table not available.
| Is This Answer Correct ? | 57 Yes | 5 No |
Post New Answer View All Answers
Mention the differences between substr and charindex in sql server.
What is difference between equi join and inner join?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What is the query and subquery?
How to create new databases with "create database" statements?
What is sql injection? How to protect against sql injection attack?
Is it possible for a stored procedure to call itself or recursive stored procedure?
Explain data warehousing in sql server?
What is the difference between a unique key and primary key?
What is the default server name for sql server?
What is the temp table?
How do you use a subquery to find records that exist in one table and do not exist in another?
Can you explain the disadvantages/limitation of the cursor?
How can delete duplicate records in cte in sql server?
What are data files?
