Book Review: The Cleaner
I read The Deceived a few weeks back and enjoyed it, even though it was the 2nd book in the...
2009-11-19
506 reads
I read The Deceived a few weeks back and enjoyed it, even though it was the 2nd book in the...
2009-11-19
506 reads
I’ve had this on my list of things to talk about someday, a recent post on almost the same subject...
2009-11-18
612 reads
In a recent blog post Brent Ozar questioned why PASS decided to relaunch the SQL Server Standard given the failure...
2009-11-17
756 reads
Last Monday was my first day back from the PASS Summit, planned for (and was) a slow day, just starting...
2009-11-16
501 reads
New friend David Easley shared two sources for hot sauce that I wasn’t familiar with:
http://www.datilsensation.com/products.shtmlhttp://www.pepperpalace.com/I like some spice here and...
2009-11-15
533 reads
I grew up watching baseball on TV and playing it too, and for reasons I don’t recall my Dad’s favorite...
2009-11-12
549 reads
A few weeks ago I was looking for a few branded items, happened to run across drink coasters at 4imprint....
2009-11-11
590 reads
I’m sure you know what I mean when I say that I feel like my ability to task switch and...
2009-11-11
492 reads
A short post today, ran across http://www.lifeoptimizer.org/2007/03/08/66-best-quotes-on-time-management/ when I was looking for ideas for my Moo cards. Quotes are fun...
2009-11-10
496 reads
I was up early again on Friday morning to have breakfast with Patrick Leblanc (SQLLunch man), and then off to...
2009-11-09
631 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Using CHOOSE()
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
Comments posted to this topic are about the item The DBA is Dead! Long...
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