when inserting to a table how many rows will be effected
using triggers
- 2 Answers
- 4177 Views
- I also Faced
- E-Mail Answers
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
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What are different type of Collation Sensitivity?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
How do I view views in sql server?
What are the different ways you can create databases in sql server?
How can I create a new template for import ? : sql server management studio
What is stored procedures?
What is a non clustered primary key?
How to retrieve error messages using mssql_get_last_message()?
How many triggers are possible per table?
Does partitioning help performance?
What do you understand by integration services in sql server?
Can you pass expressions to stored procedure parameters?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What is transact-sql language?
