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 / veerababu

Stored Procedure is a method.
Trigger is a Procedure.
Stored Procedure a specific CALL or EXECUTE has be used.
Trigger is automatically execute some specific events occure in table/views.
Stored Procedure return a Value.
Trigger is not return a value.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are unicode character string data types in ms sql server?

1157


What is isolation levels?

973


Different types of keys in SQL?

1038


what is unique and xaml nonclustered index

1003


What are trace flags?

970


Explain few examples of stored procedure over triggers?

971


How to create user messages with print statements in ms sql server?

945


Where actually sql azure database is hosted?

161


What are the different types of columns types constraints in the sql server?

1020


Can you force a query to use a specific index?

893


how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1022


What is a cube? : sql server analysis services, ssas

952


Working with TLogs

1793


How many databases instances are there in sql server 2000?

1030


Can sql server 2016 run on windows 7?

869