SQL Server 2012 Reporting Services introduced Power View, which was initially available only in SharePoint. This limited the use of...
2013-05-16 (first published: 2013-05-13)
3,460 reads
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-05-13
669 reads
I like to know what’s on the drives that are supposed to be dedicated to data and log files. So I...
2013-05-13
1,089 reads
Copy / Paste formatted text is a nightmare in WordPress. I’m singling out WordPress because I use it, and, from what...
2013-05-13
621 reads
Starting with SQL Server 2005 all tables are grouped into schemas. While creating a table if the schema name is...
2013-05-13
1,832 reads
In the same vein as Steve Jones’ series on Customizing SSMS this is a fairly basic trick, but one that...
2013-05-16 (first published: 2013-05-13)
3,867 reads
sys.dm_db_persisted_sku_features (Introduced in SQL Server 2008) DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-in/library/cc280724.aspx
Some features of the SQL...
2013-05-13
2,097 reads
As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-05-12
771 reads
This script looks much more intimidating than the results it produces, so I recommend running it before reading through it. ...
2013-05-11
483 reads
This post is inspired by Andy Warren’s ( b | t ) “Books On The Desk” post.
I’ve got plenty of SQL Server books...
2013-05-10
929 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