The Data Access Handbook - Sample Chapter
We have a sample chapter available from The Data Access Handbook, written by experts at DataDirect Technologies.
2009-05-15
1,968 reads
Press Release
Cambridge SQL UG - SSIS and SSRS sponsored by Redgate
Come and join us for this great evening focusing on SQL Server Integration Services and Reporting Services in Cambridge, UK on Wed, May 20, 2009.
2009-05-13
1,313 reads
SQL Lunch with the Baton Rouge Area SQL Users Group
Every other Monday is a lunch for the SQL Server group in Baton Rouge. If you live nearby, or are in the area, plan on attending.
2009-04-23
313 reads
SQLServerCentral To Take Over PASS
After intense negotiations with CA and Microsoft, the founding sponsors of PASS, SQLServerCentral has agreed to take over the organization.
2009-04-01
2,064 reads
SQL Server 2008 Service Pack 1 Released
Service Pack 1 for SQL Server 2008 has been released. Follow the link for more information.
2009-03-13
3,769 reads
East Iowa SQL Server Users Group
A new SQL Server user's group in Iowa is having a meeting next week.
2009-03-05
275 reads
Columbus SQL Server Users Group
If you are near Columbus, GA, a new SQL Server Users Group is starting up.
2009-03-02
299 reads
Learn SQL Server BI in Arabic
Learn about the Business Intelligence systems of SQL Server with a series of free videos in Arabic.
2009-03-02
63 reads
Sponsoring SQLSaturday!
SQLServerCentral and Red Gate software are pleased to announce our sponsorship of SQLSaturday! events.
2009-03-02
615 reads
Week of Warehousing Webinar Series
Join SQL Server authors and MVPs for a week of warehousing and get the latest on Microsoft Business Intelligence inside your environment. If you are in any stage of a data warehouse design, administration or planning you won't want to miss out on this free "week of warehousing" webinar series, free from SQLServerCentral.com and in partership with Wrox and Pragmatic Works.
2009-02-19 (first published: 2009-01-28)
9,053 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