<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
CASE
Items 1 to 9 of 9
Assigning categories to values 2
Read more...
By
Hugo Kornelis
2013/05/15
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,787 reads
Assigning categories to values 1
Read more...
By
Hugo Kornelis
2013/05/14
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,917 reads
Converting to datetime a char field with several possible date formats
Converting to datetime a char field having several possible date formats
Read more...
By
Federico Iori
2013/02/21
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,250 reads
T-SQL: CASE Statement
For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of...
Read more...
By
Jen McCown
2012/12/11
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,380 reads
Random DEFAULT string for a column using CASE and NEWID
Sometimes you just need to populate a CHAR/VARCHAR column for testing with a random selection of string literals at table CREATE time. Here is a quick and easy script.
Read more...
By
Bill Leung
2012/06/14
|
Source:
SQLServerCentral.com
|
Category:
random
Rating:
|
Discuss
|
Briefcase
|
1,066 reads
Demystifying the use of CASE in an ORDER BY statement
Chuck Hoffman exposes the mysteries of getting CASE statements to work in dynamic ORDER BY statements.
Read more...
By
Chuck Hoffman
2012/04/26
|
Source:
SQLServerCentral.com
|
Category:
case
Rating:
|
Discuss
|
Briefcase
|
14,863 reads
SQL Server CASE Law
SQLs CASE expressions can be powerful magic, but can trap the unwary that are used to the more familiar CASE statements of procedural languages.
Read more...
By
Additional Articles
2011/03/14
|
Source:
SimpleTalk
|
Category:
t-sql
Rating:
(not yet rated)
Rate this
|
Briefcase
|
5,474 reads
Case Cleanup Function
Capitalize the first letter of each new word in the string (clean, efficient, and easy to modify).
Read more...
By
Sean Smith
2013/05/24
|
Source:
SQLServerCentral.com
|
Category:
capitalize
Rating:
|
Discuss
|
Briefcase
|
190 reads
Random DEFAULT string for a column using CASE and NEWID
Sometimes you just need to populate a CHAR/VARCHAR column for testing with a random selection of string literals at table CREATE time. Here is a quick and easy script.
Read more...
By
Bill Leung
2012/06/14
|
Source:
SQLServerCentral.com
|
Category:
random
Rating:
|
Discuss
|
Briefcase
|
1,066 reads
Items 1 to 9 of 9
Tags
t-sql
(6)
blogs
(1)
capitalize
(1)
character
(1)
cleanup
(1)
convert
(1)
date manipulation
(1)
datetime
(1)
default
(1)
first
(1)
newid()
(1)
order
(1)
rand()
(1)
random
(1)
standardize
(1)
upper
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
