Interested to Buy Any Domain ? << Click Here >> for more details...
what is diffrent between store procedure and trigger
- 2 Answers
- 5279 Views
- I also Faced
- E-Mail Answers
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
What is mssql?
What are the properties of sub-query?
How to divide query output into multiple groups with the group by clause in ms sql server?
what is the difference between delete table and truncate table commands? : Sql server database administration
What is master database? : SQL Server Architecture
Why union all is faster than union?
Explain the difference between HTTP and HTTPS in database?
Show Practically Sql Server Views are updatable?
What is store procedure?
Tell me about builtinadministrator?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
Explain insert into select statement?
What is the process of normalization?
mention different types of relationships in the dbms?
What is difference between aggregate and analytic function?
