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 / vandana chand

Stored Procedure is the set of SQl statements together in the
data base.
and Trigger is the Special kind of store procedure i.e called
whenever an attempt is to modify the data.

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How you can add messages to the nt event log from within a stored procedure?

989


What is key set driven?

893


Can you explain different types of joins?

884


How will you go about resolving deadlocks?

909


is there a column to which a default can't be bound? : Sql server database administration

967


what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1066


what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

910


What are the properties of sub-query?

1024


What are the different types of cursor?

1039


What are key, name and value columns of an attribute? : sql server analysis services, ssas

946


what information is maintained within the msdb database? : Sql server administration

913


Explain the steps to create and execute a user-defined function in the sql server?

918


What is a group function explain with an example?

939


What are the purposes and advantages stored procedure?

888


What is ddl command?

926