Allows the use of CASE statements. Specifically:
Simple CASE expression:
CASE input_expression
WHEN when_expression THEN result_expression [ ...n ]
[ ELSE else_result_expression ]
END
Searched CASE expression:
CASE
WHEN Boolean_expression THEN result_expression [ ...n ]
[ ELSE else_result_expression ]
END
Namespace: DatabaseObjects.SQLAssembly: DatabaseObjects (in DatabaseObjects.dll) Version: 3.8.1.0
Syntax
| C# |
|---|
public class SQLCaseExpression : SQLExpression |
| Visual Basic |
|---|
Public Class SQLCaseExpression _ Inherits SQLExpression |
| Visual C++ |
|---|
public ref class SQLCaseExpression : public SQLExpression |
Inheritance Hierarchy
System..::..Object
DatabaseObjects.SQL..::..SQLExpression
DatabaseObjects.SQL..::..SQLCaseExpression
DatabaseObjects.SQL..::..SQLExpression
DatabaseObjects.SQL..::..SQLCaseExpression
