Explain about the process which takes place to execute a Stored routine?
Submitted by: AdministratorCREATE PROCEDURE and CREATE FUNCTION statement are used to create stored routine. It can act as a function or a procedure. A procedure can be called by using a call statement and pass output with the help of output variables. It can call other Stored routines and it can be called from the inside of a statement.
Submitted by: Administrator
Submitted by: Administrator
Read Online Stored Procedure Job Interview Questions And Answers
Top Stored Procedure Questions
☺ | Explain about the case statement present in Stored procedure? |
☺ | State the different extensions for stored procedures? |
☺ | Explain about the RETURN statement? |
☺ | Explain about the implementation of stored procedures? |
☺ | Explain about cursors? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |