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
why would you use sql agent? : Sql server database administration
What is constraints and its types?
Explain what is meant by replication of database?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
What is delete query?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is onf in normalization form?
How to execute a sql statement using mssql_query()?
Explain what are commit and rollback in sql?
Why use sub query in sql server and list out types of sub queries?
What is the difference between a stored procedure and a user defined function?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
Can binary strings be converted into numeric or float data types?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
What is a result set object returned by odbc_exec()?