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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

why would you use sql agent? : Sql server database administration

1115


What is constraints and its types?

876


Explain what is meant by replication of database?

956


What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1206


What is delete query?

896


Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

892


What is onf in normalization form?

998


How to execute a sql statement using mssql_query()?

977


Explain what are commit and rollback in sql?

864


Why use sub query in sql server and list out types of sub queries?

937


What is the difference between a stored procedure and a user defined function?

972


Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1010


Can binary strings be converted into numeric or float data types?

967


Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

887


What is a result set object returned by odbc_exec()?

950