SQL Saturday is coming to Philadelphia on June 7, 2014. This event is a free day of training and networking for SQL Server Professionals, organized by the Philadelphia SQL Server User Group. The event also features two paid-for Precons, one presented by Allan Hirt and the other presented jointly by Joseph D'Antoni and Stacia Misner. Register while space is available.
2014-05-23
1,877 reads
A new plug in for Management Studio from Red Gate is free. It will give you access to all the scripts at SQLServerCentral, including your own briefcase.
2014-05-15
3,903 reads
Just Azure, a new site from Cerebrata (part of Red Gate), provides essential technical resources and educational articles to support the Microsoft community in navigating and understanding the rapidly evolving Azure platform.
2014-05-12
445 reads
On May 31, 2014 SQL Saturday is coming to Redmond, Washington. Come for a free day of SQL Server training and networking, the schedule currently features tracks on T-SQL, SSIS, Backup & Recovery and more. Register while space is available.
2014-05-06
1,819 reads
SQL Saturday is coming to Detroit MI on May 17, 2014. Join us for a free day of SQL Server training and networking. Register while space is available.
2014-05-01
2,008 reads
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held May 10, 2014. Register while space is available.
2014-04-28 (first published: 2014-04-21)
3,770 reads
Please join us on Saturday, May 3rd, 2014, as both business analysts and IT professionals come to learn and network with experts for the first SQLSaturday Business Analytics edition. Please register while space is available
2014-04-18
314 reads
The Red Gate Database Delivery team is looking for people willing to participate in UX sessions for an exciting, brand new product, with $50 Amazon vouchers for participants.
2014-04-17
2,901 reads
This metric is useful if you want to know exactly how much physical space a particular table is taking up, including the size of its indexes. If a database is growing quickly within a short time and you suspect a certain table is responsible, you can monitor its actual size, or the rate at which it is increasing.
2014-04-15
2,050 reads
SQL Saturday will come to Atlanta on May 3, 2014. This is a free, full-day event of SQL Server training and networking. SQL Saturday #285 also has 3 (paid for) pre-con sessions available run by Kalen Delaney, Teo Lachev, and Denny Cherry. Make sure to register for SQL Saturday while spaces are available.
2014-04-11
370 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...
Nitazoxanide 500 mg Buy Online is a search term used by people looking for...
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...
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