How Do I Spell #SQLFamily? #SQLNomz Of Course
How Do I Spell #SQLFamily? #SQLNomz Of Course
Nomz (Doma Kun)
It’s time for Meme Monday again, and this month’s theme is...
2011-11-07
1,187 reads
SSSOLV November 2011 Meeting
Another month, another meeting. Time really is flying. And now with more Holidays fast approaching, I am sure that time will warp on us. The Las Vegas user group...
2011-11-07
9 reads
SSSOLV November 2011 Meeting
Another month, another meeting. Time really is flying. And now with more Holidays fast approaching, I am sure that time...
2011-11-07
580 reads
SQL Server 2012: New Certifications
As a follow-up to my post SQL Server “Denali”: New Certifications, the seven exams for SQL Server 2012 are:
Querying Microsoft...
2011-11-07
3,480 reads
Financial Transparency is Good for Community
I was recently in a conversation with several people that had previously organized one or more community events. The topic...
2011-11-07
891 reads
Slide Decks for PASS, SQL in the City, and SQL Server Connections
I’ve sent my slide decks to the organizers, but I know they don’t always get posted. So I’m putting a...
2011-11-07
951 reads
SQL Server A to Z – User-Defined Functions
The alphabet is quickly winding down (so sad). We’re up to the letter U and that stands for User-defined functions.
What...
2011-11-07
1,370 reads
SQL University: Advanced indexing – Sorting and Grouping
Good day everyone and welcome to another week of SQL University. I know we’re getting close to the end of...
2011-11-07
2,704 reads
Meme Monday: SQL Family
Tom LaRock’s (blog|twitter) question this month: What does #sqlfamily mean to me?
Wow…
Geez Tom, couldn’t you ask a hard question for...
2011-11-07
1,792 reads
We are Family
It has been a while since I last wrote something for a meme monday. This month is a perfect time to jump back in the deep end. If you...
2011-11-07
8 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Using CHOOSE()
Comments posted to this topic are about the item Using CHOOSE()
Re-Seeding a Broken Log Shipping Secondary (Without Touching the Primary)
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
The DBA is Dead! Long Live the !
Comments posted to this topic are about the item The DBA is Dead! Long...
Question of the Day
Using CHOOSE()
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