A Fire Drill and Voter Registration
I avoid politics here, a discussion best done in other places, but hope you’ll enjoy some thoughts about a recent...
2012-06-26
799 reads
I avoid politics here, a discussion best done in other places, but hope you’ll enjoy some thoughts about a recent...
2012-06-26
799 reads
I was just browsing the results of the presentations at SQLRally 2012. I ended up with a evaluation average of...
2012-06-25
647 reads
As you may surmise from my previous post I’m back from vacation. I was as unplugged as I’ve been in...
2012-06-21
570 reads
I wrote this over the course of 10 days, so it’s a bit rambling, but maybe you’ll find a good...
2012-06-20
803 reads
I’m at Orlando International as I write this, about to fly to Parsippany for meetings today and tomorrow, then back...
2012-06-06
634 reads
I was disappointed to see the mention in the Connector today that there would be no SQLRally 2013 in the...
2012-05-31
1,713 reads
It’s been interesting to watch the characters evolve on NCIS over the years, something that can only happen with time...
2012-05-29
856 reads
One of the things I’ve been doing lately is pruning (again) the number of newsletter type emails I get. Some...
2012-05-28
837 reads
This idea came up during a critique of a presentation. I may have re-invented (or re-labeled) something that is already...
2012-05-25
628 reads
I’m fond of replying with “done” when a task is complete, no need for anything more elaborate. I’ve been experimenting...
2012-05-25
592 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