2014-06-12
7 reads
2014-06-12
8 reads
2014-06-12
6 reads
2014-06-12
21 reads
Presentation DAC “SQL Server Implementation Framework From Dev to Prod”
The San Francisco SQL Server User Group – June 11 2014 Uploading presentation DAC for Today’s session….
2014-06-12
625 reads
SQLSaturday in Vermont, Idaho, South Dakota, Montana, Alaska, Arkansas, Mississippi, and Wyoming
Did the list of states in the title catch your eye? That’s the list of states where PASS is trying...
2014-06-11
528 reads
Status and Name Please-Question Of The Day
Status and Name Please is my latest Question of the Day at SQLServerCentral. This is a fairly easy question, but...
2014-06-11
403 reads
SQL Server with Red-gate SQL Source Control – Working folder management with TFS
I’ve already spoken about source controlling database using Visual Studio Online and Red-Gate SQL Source Control in this post. The described kind...
2014-06-11
1,370 reads
ETL vs ELT Data Migration
ETL Process
Reporting databases need to consolidate data from across many applications within an organization. In order to successfully pull data...
2014-06-11
1,527 reads
PASS Events
PASS Summit
PASS Summit is the world’s largest and most intensive technical training conference for Microsoft SQL Server and BI professionals....
2014-06-10
687 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