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 are types of scd? : sql server analysis services, ssas
Explain what are partitioned views and distributed partitioned views?
What is the use of keyword with encryption.
Tell me what is the difference between locking and multi-versioning?
Explain how you can deploy an SSRS report?
What is a primary index?
Does group by or order by come first?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
which table keeps the locking information? : Sql server administration
What is exporting utility?
How do I find sql server instance name?
What are relationships and mention different types of relationships in the dbms
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
Can you roll back the ddl statement in a trigger?
What does executeupdate return?