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

What is difference between Triggers and store procedure?

Answer Posted / vidit tyagi

triggers are events which fires automaticaly when any insert
,update or delete command execute
but in case of stored procedure we have to manualy
execute / fire to procedure

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1066


What is meant by indexing files?

1025


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

915


What is optimistic concurrency?

1017


How to insert multiple rows with a subquery?

1107


Explain the stored procedure?

1031


Explain transaction isolation levels in sql server?

1093


While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

109


Why would you call update statistics?

998


What does Master database contains?

1113


What is database architecture? : SQL Server Architecture

1018


Comment,Datatypes are unlimited

2049


What are the types of ssrs?

145


Explain activity monitors

1055


When you should use a low fill factor?

981