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 happens when converting big values to integers?

0 Answers  

Can a cursor be updated? If yes, how you can protect which columns are updated?

0 Answers  

What do you mean by a Composite primary key?

0 Answers   Genpact,

What is database mirroring?

0 Answers  

What are the different types of normalization?

0 Answers  




How do I get to sql server configuration manager?

0 Answers  

Explain what are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  

Explain full-text indexing?

0 Answers  

How to delete the duplicate rows from a table in SQL Server ??

3 Answers  

What are character string data types in ms sql server?

0 Answers  

Explain about local stored procedure?

0 Answers  

What is de-normalization in sql database administration? Give examples?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories