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

Difference between Triggers and Stored Procedure

Answer Posted / naveen jindal

trigger fired implicitely that is when ever events like
insert/update/delete commands.

Where as stored procedure is not fired implicitely. when
ever we call then only the stored procedure fire.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention the uses of stored procedures.

1004


How to create new tables with "select ... Into" statements in ms sql server?

1042


Explain concepts of analysis services?

1011


is it important for a database administrator to understand the operating system and file access? : Sql server administration

1070


Explain datetimeoffset data type in sal server 2008?

957


but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

1009


What is sql server management studio? : sql server management studio

1118


What is the openxml statement in sql server?

1114


What are the different types of cursor?

1142


What are the built in functions in sql server?

1022


What is 1nf 2nf?

1057


In what three ways is the return statement used in a stored procedure?

1060


Write an SQL query to obtain the 2nd highest salary.

1122


What is the difference between coalesce() & isnull()?

1184


What is the Main Difference between ACCESS and SQL SERVER?

1180