T-SQL Case Statement Example

Programming Interviews Series: SQL CASE statement examples

It is quite difficult to write a stored procedure or a function if you do not know or understand the SQL conditional processing statements. From an interview perspective, you ...

http://www.programminginterviews.info/2011/06/sql-case-statement-examples.html

SQL SERVER – CASE Statement/Expression Examples and Explanation ...

CASE expressions can be used in SQL anywhere an expression can be used. Example of where CASE expressions can be used include in the SELECT list, WHERE clauses, HAVING clauses ...

http://blog.sqlauthority.com/2007/04/14/sql-server-case-statementexpression-examples-and-explanation/

Speeding UPDATEs Using the CASE Statement - SQL Server Performance

Introduction One of the keys to SQL Server database performance if keeping your transactions as short as possible. In this article we will look at a couple of tricks using the ...

http://www.sql-server-performance.com/2002/case-statement/

SQL SERVER – CASE Statement in ORDER BY Clause – ORDER BY ...

This article is as per request from Application Development Team Leader of my company. His team encountered code where application was preparing string for ORDER BY clause of ...

http://blog.sqlauthority.com/2007/07/17/sql-server-case-statement-in-order-by-clause-order-by-using-variable/

SQL SELECT Statement

Well organized easy to understand SQL tutorial with lots of examples. Including PHP, ASP, ADO, Oracle, Access, SQL Server. Related: HTML, JavaScript, XML, XQuery

http://www.w3schools.com/sql/sql_select.asp

CASE Statement

Oracle® Database PL/SQL User's Guide and Reference 10g Release 2 (10.2) Part Number B14261-01

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/case_statement.htm

sql server - SQL Case Statement Syntax? - Stack Overflow

What is the complete and correct syntax for the SQL Case statement?

http://stackoverflow.com/questions/4622/sql-case-statement-syntax

Using CASE Statements In A SQL UPDATE Query

Ben Nadel's web development blog on ColdFusion, jQuery, HTML5, AJAX, SQL, and all aspects of web application development.

http://www.bennadel.com/blog/933-Using-CASE-Statements-In-A-SQL-UPDATE-Query.htm

CASE Statement in Where Clause? - Microsoft SQL Server

CASE Statement in Where Clause?. Get Microsoft SQL Server help and support on Bytes Support Forums.

http://bytes.com/topic/sql-server/answers/79750-case-statement-where-clause

The PL/SQL CASE Statement

The PL/SQL CASE Statement, WHEN Clause

http://www.remote-dba.cc/t_easyoracle_pl_sql_case_statement_when_clause.htm