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 the difference between clustered and a non-clustered index?
What is inner join in sql server joins?
What is a trace frag?
What are cursors and when they are useful?
What is msdb database? : SQL Server Architecture
How can a user-defined datatype be created?
How to handle error or exception in sql?
What do you understand by a view?
Explain optimistic and pessimistic concurrency?
What is the report builder?
Explain index in sql server?
Can sql servers link to other servers like oracle?
Do you know the policy based administration feature of sql server 2008?
What is the use of tempdb? What values does it hold?
What is sub-query in sql server?