Cumulative Update – 1 for SQL Server 2012 Service Pack 2 Is Now Available !
The 1st cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft...
2014-07-27
761 reads
SQLSaturday Porto Edition 2014 Selection Process Results & Voting
This blog post is a continuation of the initial announcement almost a month ago about the session selection process that...
2014-07-25
214 reads
SQLBits XII Recap
There are different type of events – good ones, great ones, mediocre ones, bad ones & excellent ones.
There is a technological event...
2014-07-25
212 reads
Webinar Q&A: Getting Started with Change Data Capture
Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics...
2014-07-25
1,474 reads
Speaking on ETL Security
I will be giving a presentation on ETL (Extract, Transform, Load) security at two user groups in the coming weeks.
Securing...
2014-07-25
882 reads
Reblog: July 18 to July 24
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-07-25
816 reads
A Question From The NomCom
One of the many things we’re discussing going into the 2014 PASS election is what the planned two official campaign...
2014-07-25
668 reads
Friday Followup For July 25, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-07-25
372 reads
Thank You SQLBits!
Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party...
2014-07-25
139 reads
Thank You SQLBits!
Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party...
2014-07-25
637 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Using CHOOSE()
Comments posted to this topic are about the item Using CHOOSE()
Re-Seeding a Broken Log Shipping Secondary (Without Touching the Primary)
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
The DBA is Dead! Long Live the !
Comments posted to this topic are about the item The DBA is Dead! Long...
Question of the Day
Using CHOOSE()
We have this code that sets some status values and then queries them using the CHOOSE() function in SQL Server 2025.
CREATE TABLE Status
(
StatusID INT,
StatusDescription VARCHAR(20)
);
GO
INSERT dbo.Status
(
StatusID,
StatusDescription
)
VALUES
(0, 'Uncategorized'),
(1, 'Active'),
(2, 'Inactive'),
(3, 'Temp');
GO
SELECT CHOOSE(StatusID, 'Unknown', 'Active', 'Inactive', 'Temporary')
FROM Status;
When the SELECT runs, what is returned? See possible answers