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...


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

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 difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,


How network traffic be reduced by using the stored procedure?

0 Answers   Accenture,


How many primary keys are possible in a table?

0 Answers  


How can we check the sql server version?

0 Answers  


How many partitions a clustered index has by default in sql server 2012?

0 Answers  


What do you understand by replication in sql server? Mention the different types of replication in sql server.

0 Answers  


Define model database?

0 Answers  


What is 2nf example?

0 Answers  


Explain indexed views?

0 Answers  


Explain what are the basic functions for master, msdb, model, tempdb databases?

0 Answers  


Tell me what is the stuff and how does it differ from the replace function?

0 Answers  


Explain encryption of entire databases without the need for application changes in sql server 2008?

0 Answers  


Categories