Add support for SQL CASE statements #23

Closed
hisystems opened this Issue Mar 5, 2012 · 1 comment

Projects

None yet

1 participant

@hisystems
Owner

Add support for the SQL CASE statement. Only TSQL support is required at this stage.

@hisystems hisystems was assigned Mar 5, 2012
@hisystems
Owner

http://msdn.microsoft.com/en-us/library/ms181765.aspx

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

@hisystems hisystems added a commit that closed this issue Mar 6, 2012
@hisystems Added support for SQL CASE statements. Closes #23.
Added TSQL support for:

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
5624eb0
@hisystems hisystems closed this in 5624eb0 Mar 6, 2012
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment