Interested to Buy Any Domain ? << Click Here >> for more details...
Can we execute a stored procedure inside a trigger?
- 6 Answers
- 24723 Views
- BirlaSoft, CarrizalSoft Technologies, United Healthcare, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / uttam singh rawat
Yes , we can execute the proc inside the trigger
exce proce_name(param,param1)
| Is This Answer Correct ? | 35 Yes | 5 No |
Answer / mohd masood siddiqui
Yes, we can call a stored procedure.
SQL doesn't have a row trigger. Triggers fire once per
statement, not per row. Hence it's not recommended to have
triggers call procedures that have to execute one row at a
time. It's slow.
| Is This Answer Correct ? | 13 Yes | 3 No |
Answer / sql2000
The question is asking for if a SP can be executed from
within a trigger. In MS SQL 2000 have executed and this is
possible.
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / 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 |
Answer / swetha
No you can't call stored procedure inside triggers.
| Is This Answer Correct ? | 11 Yes | 29 No |
Answer / digambar patil
no, we cannot execute stored procedure in trigger.
| Is This Answer Correct ? | 2 Yes | 20 No |
What is cube dimension? : sql server analysis services, ssas
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What will happen when a Rollback statement is executed inside a trigger?
1 Answers Flextronics, Hexaware,
What are the parts of a function?
What is the order in which the sql query is executed?
What is failover clustering overview?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is shared lock?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
What is model database in sql server?
Explain about extended stored procedure?
Explain different types of collation sensitivity?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
