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

whats the maximum size of view state??

0 Answers  

Name 3 ways to get an accurate count of the number of records in a table?

0 Answers  

How to create a dml trigger using create trigger statements?

0 Answers  

What is a file group?

0 Answers  

what is an sql server?

1 Answers  

What is service broker? : sql server database administration

0 Answers  

How does using a separate hard drive for several database objects improves performance right away?

0 Answers  

What is SQL Profiler what is the use of it?

2 Answers   247Customer, Steria,

What is normalization? What number of normalization shapes are there?

0 Answers  

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  

What is surrogate key? : sql server analysis services, ssas

0 Answers  

Explain what are the events recorded in a transaction log?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories