Grasshopper
During a recent class I happened to mention something about grasshopper, and a student wasn't familiar with the reference to...
2008-12-25
1,781 reads
During a recent class I happened to mention something about grasshopper, and a student wasn't familiar with the reference to...
2008-12-25
1,781 reads
I'm enjoying today with family and hope you are as well. Nothing complicated today, just some appropriate music!
Bruce Springsteen - Santa...
2008-12-24
1,470 reads
It was only a year ago that I moved from the Blackjack to the Blackberry Curve and overall I was...
2008-12-23
1,420 reads
SQL Agent is one of the handiest subsystems in SQL Server. This video shows how you can schedule a one-time job to handle something without you being there.
2008-12-23
3,907 reads
I guess I'm stuck in the past, but the Office Ribbon still hasn't grown on me. I think it makes...
2008-12-22
746 reads
There's one report that I look at every day to assess how things are going on a project we launched...
2008-12-21
621 reads
Last and not least this week, The Snowball: Warren Buffett and the Business of Life. This is an authorized biography...
2008-12-18
715 reads
My friend Jack has been blogging for almost a year now and is looking for feedback. If you're a blogger...
2008-12-18
599 reads
I'm still finishing up two books that I'll mention today. Most non-technical books I read straight through, anything technical/learning based...
2008-12-17
549 reads
Magazines today instead of books, but hopefully you'll count that as close enough to my theme of the week. I...
2008-12-17
545 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