when inserting to a table how many rows will be effected
using triggers
Answer Posted / veeresh kethari
Before commit in the database,data will get store in the
INSERTED table in trigger. From the table we can come to
know how many records are affected in the table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is sql server agent and what are the two modes of authentication in sql server?
What is clustered vs nonclustered index?
Explain what is raid and what are different types of raid levels?
Explain the Ways to improve the performance of a sql azure database?
how can a database be repaired? : Sql server administration
What is 5nf in normalization form?
How do you open a cluster administrator?
How to disable triggers using "disable trigger"?
What command would you use to add a column to a table in sql server?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
Explain differentiate between a having clause and a where clause?
What are rows and columns?
What is delete query?
What is the importance of concurrency control?