Stored Procedure Question:

Download Job Interview Questions and Answers PDF

Explain about the case statement present in Stored procedure?

Stored Procedure Interview Question
Stored Procedure Interview Question

Answer:

CASE 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.

Download Stored Procedure Interview Questions And Answers PDF

Previous QuestionNext Question
How do you notify DBPAK about Stored Procedure?What is a stored procedure?