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 diffrent between store procedure and trigger

Answer Posted / sankar

1)Actually Trigger is an action which is performed
automatically after or before an event occure. But Store
procedure is executed when it is call.

2)We can call Trigger inside the store procedure. But
reverse is not possible.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is molap and its advantage? : sql server analysis services, ssas

965


What are the different methods available under sqlcommand class to access the data?

1096


What is #table in sql server?

1027


What is named query? : sql server analysis services, ssas

942


Explain what is analysis service repository?

967


Explain having clause?

946


What are the default system databases in sql server 2000?

997


What is user-defined multi-statement table-valued function?

1032


Can we use pragma autonomous_transaction in trigger?

938


What is the difference between clustered and a non-clustered index?

1009


How many triggers are possible per table?

1070


What does COMMIT command do?

1034


Is t sql the same as sql server?

945


What are null values in ms sql server?

1056


What is trigger and different types of Triggers?

1117