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
How to execute function in stored procedure sql server?
what are the new features introduced in sql server 2000? : Sql server database administration
What is reportserver and reportservertempdb ?
What is truncate table?
Explain the various types of concurrency problem?
What happens if you are trying to access a schema not owned by you?
List the different index configurations possible for a table?
Can you use order by when defining a view?
Explain isolation levels that sql server supports?
Describe and explain about SQL native client?
What are the advantages of using cte?
why would you call update statistics? : Sql server database administration
How to backup SQL Server Reporting Services ?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What are ddl triggers and types of ddl trigger?