Interested to Buy Any Domain ? << Click Here >> for more details...
when inserting to a table how many rows will be effected
using triggers
- 2 Answers
- 5122 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
What the different components of Replication and what is their use?
What is a transactions?
Explain cross join or cartesian product in sql?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What is the sql profiler?
How do I open a .db file?
User wants only to display only pdf as export option in report manager. How to achieve this?
What are the differences between stored procedure and view in sql server?
Differentiate between a primary key and a unique key.
How can we migrate from SQL server to SQL Azure?
How to write a query with a left outer join in ms sql server?
How can we remove orphan records from a table?
What is the significance of null value and why should we avoid permitting null values?
How column data types are determined in a view?
How to create dbo table in sql server?
