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

Wht is the difference between stored procedure and trigger

Answer Posted / jerry joseph

Stored Procedures does not execute automatically

Triggers are a special type of Stored procedure which
executes automatically

Types of Triggers
- INSTEAD OF triggers
- AFTER Triggers

Is This Answer Correct ?    15 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a mixed extent? : Sql server administration

1175


How can you list all the table constraints in a database?

983


What are the types of database recovery models?

1188


Define constraints and give an example of their use?

1096


what is normalization? Explain different levels of normalization? : Sql server database administration

1412


How many database files are there in sql server 2000?what are they?

1108


OPTIMIZATION OF SP,CURSOR,TRIGGERS

2856


What is ssl in sql server?

1134


What are temporal tables in sql server 2016?

930


How to transfer an existing table from one schema to another schema in ms sql server?

1023


What is a linked server in sql server?

1134


What is mean by candidate key?

1061


How does recursive cte works in sql server?

1059


What is the difference between a "where" clause and a "having" clause?

1211


Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1038