Internet Explorer Vulnerability
If you're using Internet Explorer, be advised Microsoft has released a
security advisory for Internet Explorer. This would allow an attacker
to...
2006-03-28
1,569 reads
RegCreateKeyEX() error
I just began migrating SQL Servers (2000) to Windows 2003 from Windows 2000 a few months ago. In the past, I...
2006-03-27
2,943 reads
Is Documentation Dying?
The BOL for SQL Server 2005 has been interesting to read. On one hand there is a more comprehensive approach...
2006-03-24
1,531 reads
Blue Hat
Microsoft had their Blue Hat security conference recently, inviting hackers to take their shots at the Microsoft products. Mostly security...
2006-03-16
1,569 reads
Rights within the database
This is a follow-on to my post What are the actual rights?
First and foremost, I want to include membership in...
2006-03-14
1,426 reads
What are the actual rights?
One of the things I've started to work on are some scripts to quickly
be able to pull what a user's...
2006-03-14
1,455 reads
Tool Updates
Catching up on recent updates for tools I've looked at and/or recommended.
SQL Server Tools:
PromptSQL is now up to version 1.4....
2006-03-13
1,575 reads
First Impressions of Professional SQL Server 2005 Integration Services
I received a copy of Professional SQL Server 2005 Integration Services
a few weeks back from Kathi. Because of illness and...
2006-03-13
1,495 reads
Microsoft MVP Program
I think anyone who posts actively in the various on-line forums for
Microsoft products (such as SSC.com) hopes one day to...
2006-02-23
1,380 reads
Picking Things Apart
One of the challenges in writing about a new version of SQL Server is
finding out information, especially for the less...
2006-02-20
1,412 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