Sometime we need to find out the history of database restoration to get the answers of following questions: -1) Do we need to restore the database again as there...
2018-03-30
21 reads
Sometime we need to find out the history of database restoration to get the answers of following questions: -
1) Do...
2018-03-30
8,171 reads
Introduction: -
We live in an era of “Automation”. Planes run on auto pilot mode, cars will soon be auto driven,...
2018-03-30
890 reads
SQL Server Install Requirements
SQL Server Installation requirements indicate .NET 3.5, 4.0, or 4.6 depending on the version. This is not including SSMS. At this point you shouldn’t use SSMS...
2018-03-30
30 reads
Some of my friends know I am a huge fan of the song “Havana” by Camila Cabello. They also know I like to remix songs and if I was...
2018-03-29
24 reads
Some of my friends know I am a huge fan of the song “Havana” by Camila Cabello. They also know...
2018-03-29
1,533 reads
I am proud to present a free webinar for the PASS Virtualization virtual chapter entitled “Level Up Your Cloud Infrastructure...
2018-03-29
425 reads
I’ve been wanting to share a little bit about Matt’s story for a while now and this past week I...
2018-03-29
899 reads
This is the third update for my goals for 2018. This is about 3 weeks after the last update, and...
2018-03-29
991 reads
Here’s a quickie that I’ve just stumbled across.
I’ve just tried to initiate a manual failover of an availability group and...
2018-03-29
529 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