Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

Write a SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

Define Unique Key?

0 Answers   HCL,

What is a view? is View updatable?

17 Answers   IBM, L&T,

Is it ok to shrink transaction log?

0 Answers  

Which database stores information about replication?

0 Answers  

Tell me the phases a transaction has to undergo?

0 Answers  

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

0 Answers  

How to create a ddl trigger using "create trigger" statements?

0 Answers  

What is model database in sql server?

0 Answers  

What is a ddl statement?

0 Answers  

How to perform backup for certificates in sql server? : sql server security

0 Answers  

What is the use of toad or sqldbx.?

0 Answers   MCN Solutions,

For more SQL Server Interview Questions Click Here
Categories