T SQL - CASE or IF

T SQL - CASE or IF

search resultsCASE (Transact-SQL) - Resources and Tools for IT ...
CASE (Transact-SQL ) SQL Server 2012 ... Category = CASE ProductLine WHEN
'R' THEN 'Road' WHEN 'M' THEN 'Mountain' WHEN 'T' THEN 'Touring ' WHEN 'S'
THEN ...
technet.microsoft.com/en-us/library/​ms181765 - Cached

In T-SQL, use CASE...WHEN in place of IF...THEN - TechRepublic
Add some flexibility to your program flow in T-SQL with the CASE...WHEN
statement. Get a hands-on look at the statement's syntax and the
advantages it can provide ...
www.techrepublic.com/article/in-t-sql-​use-casewhen-in... - Cached

The Power of SQL CASE Statements - 4GuysFromRolla.com
Now that we've looked at the generic syntax for T-SQL CASE statements,
let's turn our attention to examining how CASE can be used in real-world
applications.
www.4guysfromrolla.com/webtech/102704-​1.shtml - Cached

sql server - How do you perform an IF...THEN in an SQL SELECT ...
Microsoft SQL Server (T-SQL) In a select use: select case when Obsolete =
'N' or InStock = 'Y' then 'YES' else 'NO' end In a where clause, use:
stackoverflow.com/questions/63447 - Cached

T-SQL Programming Part 5 - Using the CASE Function ...
The CASE function is a very useful T-SQL function. With this function you
can replace a column value with a different value based on the original
column value. An ...
www.databasejournal.com/features/mssql/​article.php/3288921 - Cached

SQL Server Update: "Using CASE Expressions"
WHERE t.title_id = ta.title_id) ... Any criteria that can be expressed in
terms of SQL predicates in CASE expressions can be used to update rows
conditionally.
www.craigsmullins.com/ssu_0899.htm - Cached

sql server - SQL: IF clause within WHERE clause - Stack Overflow
It's easy to forget that CASE doesn't work like that. ... I am using
T-SQL. Scenario: Let's say you want to get Person-30's hobbies if bool is
false, ...
stackoverflow.com/questions/87821 - Cached

SQL CASE Expression - 1Keydata - 1Keydata - Free Online ...
Explains the CASE expression in SQL. Click here to learn the syntax and
see examples of how to use CASE in SQL.
www.1keydata.com/sql/sql-case.html - Cached

CASE vs. IF/ELSE in T-SQL ISNULL - SQL Server Central ...
I am truncated with some T-SQL statements. The objective is to check for
an empty string AND a Null value within a specific column of data in a
row.
www.sqlservercentral.com/Forums/​Topic1101944-8-1.aspx

T-SQl Select Case Example - Master of None
Simple HTML Scripting and Design Examples. T-SQL: Select Case Example.
Jack Donnell, jack@JackDonnell.com. Select Case allows you to present data
in various way.
www.jackdonnell.com/articles/Sql_​Case.htm - Cached