Search:
www.rocket99.com : Technical Guides
Sybase
Oracle
UNIX
Javascript
Technical Guides
Sybase
Oracle
UNIX
Javascript
After Work
The best club in Chicago
for Chicago Singles is
Highlife Adventures
!
Are you looking for a
Jersey Girl T-Shirt
?
Kyoto Sushi
in Chicago, on Lincoln Ave.
Moody's Pub
in Chicago, has great burgers
Skylark
in Chicago, on Halsted .. excellent
Friday fish fry
!
Sybase » Transact-SQL » Coding »
Case Statement
Sample for case statement usage appears below.
SELECT emp_name,
(CASE WHEN salary = 0
THEN "not hired"
ELSE "has salary" END) AS salary_note,
hire_dt
FROM emp_table
Sybase : Related Topics
Sybase : Transact-SQL : Transact SQL: numeric functions
Sybase : Transact-SQL : Transact SQL: string functions
Sybase : Transact-SQL : Transact SQL: date/time functions
Sybase : Transact-SQL : Transact SQL: misc functions
Sybase : Transact-SQL : Transact SQL: Conditionals
Sybase : Transact-SQL : Transact SQL: looping constructs
Sybase : Transact-SQL : Transact SQL: Cursors
Sybase : Transact-SQL : Transact SQL: Complex Updates
Sybase : Transact-SQL : Transact SQL: Finding duplicate rows in a table
Sybase : Transact-SQL : Using Temporary Tables
Sybase : Transact-SQL : Inner/Outer Joins
Sybase : Transact-SQL : Isolation Levels
Sybase : Transact-SQL : Reporting: SQL Performance and Tuning
Sybase : Transact-SQL : Date processing: stripping time from datetime
Sybase : Transact-SQL : Safely delete a large number of rows without blowing the t-log
Sybase : Transact-SQL : Transact SQL: date/time formats
Sybase : Transact-SQL : Creating a stored procedure
Sybase : Transact-SQL : Custom query plans
Sybase : Transact-SQL : Rowcount setting - limiting result sets
Sybase : Transact-SQL : Ranking Data - with Duplicates
Sybase : Transact-SQL : Forcing an index in a query
Sybase : Transact-SQL : Median Calculation, with pure SQL
Sybase : Transact-SQL : Lead and Lag with pure SQL
Sybase Web Site
Sybase Mobile Web Site
Oracle Web Site
Site Index
About this Guide to Sybase, Oracle, and UNIX
Contact Us
Advertise on this site
Copyright © 2008
Citisoft Inc
All Rights Reserved.