Can we execute a stored procedure inside a trigger?
Answer Posted / reva ram sahu
Triger are executed automatically so we can't call them
within a stored procedure or within a function they are
executer explicitly when any DML command take place and also
fire in case of sql server 2005 whenere there is any DDL
command such as create table/proce or alter table/proce
Is This Answer Correct ? | 4 Yes | 11 No |
Post New Answer View All Answers
what are cursors? : Sql server database administration
Explain what are commit and rollback in sql?
Where is trigger in sql server?
explain databases and sql server databases architecture? : Sql server database administration
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Explain transaction server explicit transaction?
Write an SQL query to obtain the 2nd highest salary.
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
What is sql service broker?
What is pessimistic concurrency?
Explain different types of lock modes in sql server 2000?
How do I save a stored procedure in sql server?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What you can do to delete a table without the delete trigger firing?
What is difference between clustered index and non clustered index?