Looking for Incremental Improvements
If you've read my blog much you'll know that I'm deeply involved in trying to figure out how to build...
2008-05-01
546 reads
If you've read my blog much you'll know that I'm deeply involved in trying to figure out how to build...
2008-05-01
546 reads
I grabbed Pro SQL Server 2005 High Availability by Allan Hirt recently to add to the library and I've been...
2008-04-30
1,373 reads
Raffle tickets have become a mainstay of our events, making it easy to handle the large volume of items donated...
2008-04-29
1,620 reads
Two weeks ago I did five posts on mentoring, and based on that I received a couple interesting notes, here...
2008-04-28
1,383 reads
Just checked the registrations and we're at 354, with plenty of room for more! Brian has been busy tweaking the...
2008-04-28
1,366 reads
My friend Ken Tucker invited me to speak on June 11, I'll be doing a short presentation on SQL performance...
2008-04-28
1,569 reads
I attended this on Friday along with fellow oPASS members Mike Antonovich and Ulysses Vasquez to represent PASS, and we...
2008-04-27
1,521 reads
The April 15, 2008 edition of SDTimes (PDF download here) has some information about SSDS, the SQL Server in the...
2008-04-27
1,510 reads
Steve Jones recently posted an editorial about LINQ and the resulting discussion encapsulates most of the points of view on...
2008-04-24
1,783 reads
Ran across this in the Mar/Apr ACM Queue, http://www.eecs.berkeley.edu/IPRO/JimGrayTribute/ will be held at UC Berkeley on May 31st, 2008. Jim Gray...
2008-04-24
1,362 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