Explain about the case statement present in Stored procedure?
Submitted by: AdministratorCASE statement contains a complex conditional construct. If a certain statement is evaluated as true then the search_condition makes sure that the following statement gets executed. If there are no true statements are present then the ELSE clause is executed. An error is generated if there is no 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. |
☺ | Sybase Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |