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

What is the template in sql?

0 Answers  

What are the parts of a function?

0 Answers  

what is isolation level at dead lock?

0 Answers   Verizon,

Write an SQL query to obtain the 2nd highest salary.

0 Answers   Akamai Technologies,

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

0 Answers  




Can you explain full-text query in sql server?

0 Answers  

from the table display the 2nd highest salary? and also the least 2nd salay?

8 Answers  

Explain system scalar functions?

0 Answers  

What is sparse columns of sql server 2008?

0 Answers  

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 Answers  

When columns are added to existing tables, what do they initially contain?

0 Answers  

Comment,Datatypes are unlimited

0 Answers   IBM,

For more SQL Server Interview Questions Click Here
Categories