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
Can you tell me about the concept of ER diagrams?
what are constraints? Explain different types of constraints? : Sql server database administration
What stored by the tempdb ? : sql server database administration
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
Can we write a distributed query and get some data which is located on other server and oracle database?
How to use column default values in insert statements in ms sql server?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What is 'write-ahead log' in sql server 2000 ?
What is the default Port No on which SQL Server listens?
Define left outer join?
What is indexing and its types?
Why we should not use triggers?
What is 3nf normalization?
What is the difference between a local and a global temporary table?
What is schemabinding a view?