1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

when inserting to a table how many rows will be effected
using triggers

Question Posted / guest

Answers were Sorted based on User's Feedback



when inserting to a table how many rows will be effected using triggers ..

Answer / sharjeel

All Rows Check and effects.
When ever condition must true/false then it breaks and show
the result

Is This Answer Correct ?    2 Yes 1 No

when inserting to a table how many rows will be effected using triggers ..

Answer / 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

More SQL Server Interview Questions

How to encrypt Strored Procedure in SQL SERVER?

0 Answers  

What do you mean by sql server agent?

0 Answers  

What Is The Difference Between Primary Key & Super Key

3 Answers   Accenture,

write the query for taking database restore in sql?

2 Answers  

What is difference between cte and view?

0 Answers  




Differences between functions and stored procedures?

8 Answers   247Customer, Accenture,

Do you know what are the reporting services components?

0 Answers  

What are the commands used in DCL?

0 Answers  

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com

35 Answers   Oracle, Scend, TechInfini,

Create and insert into temp table in sql server?

0 Answers  

Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  

What is xdr?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories