Updated SQLRally Flyer
We’ve updated the original flyer to the new and improved model that has the prices. The image below is a...
2010-12-23
720 reads
We’ve updated the original flyer to the new and improved model that has the prices. The image below is a...
2010-12-23
720 reads
I read a lot, and often marvel at the effort that goes into writing them, and I think I get...
2010-12-22
622 reads
Lately I’ve been having some unusual lunches, starting with the bbq fiasco from last week. For this one I have...
2010-12-20
590 reads
Sent by a friend (yes, it’s a mild fake), but still, shouldn’t someone open a SQL bar or coffee place?
2010-12-17
589 reads
This Friday we have a guest editorial from Andy Warren that asks about those features in SQL Serve that you find very useful, but perhaps aren't as well known.
2010-12-17
612 reads
Recently some friends invited me to try a BBQ place that they enjoyed, so I went along hoping for the...
2010-12-17
600 reads
Our December meeting was a time for a lot of changes:
New location, the Hampton Inn in Lake Mary. It’s further...
2010-12-16
599 reads
Email consumes a pretty significant chunk for me. Email for my day job, email for my blog, email from friend...
2010-12-15
878 reads
Over my career I’ve seen interviews fall into three categories:
The technical part. Questions on trace flags, wait states, backups, etc,...
2010-12-14
617 reads
I’ve happened to have a few networking events happen recently that I thought I’d share, all part of trying to...
2010-12-13
651 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