SQL Server for VM Admins vBrownBag Webinar
Next Wednesday, August 20th, at 7:30pm Central I will be presenting a webinar for the Professional VMware #vBrownBag entitled “SQL...
2014-08-13
616 reads
Tableau Conference Is Bigger Than PASS Summit
I was reading http://paultebraak.wordpress.com/2014/08/11/the-wisdom-of-the-tableau-crowd/ and, no disrespect intended at all to the Tableau universe, I was astounded to see that...
2014-08-13
514 reads
Max() function in SQL Server
Max():- This function gives the maximum value of the selected column
Syntax:-
Select Max (col1) from table_name
In this article, we are...
2014-08-13
844 reads
AND and OR Operator in Sql Server
And & Or:- These Operators are used to further filter the recordset return by SQL queries when more than one conditions...
2014-08-13
570 reads
RTRIM() function in SQL Server
RTRIM():-This function is used to get the string after the removal of all trailing blanks.
Syntax:-
RTRIM ( character_expression )
For example:-
Select RTRIM('Vivek Johari ...
2014-08-13
917 reads
T-SQL Tuesday #57: SQL Family and Community
Well, here it is again. The second Tuesday of the month, which means that it’s T-SQL Tuesday. T-SQL Tuesday… that...
2014-08-13
629 reads
Building a Virtual Machine within Azure (IaSS) – Improvements !
Those Dev’s/UX designers out there at Microsoft seems to be pretty busy as they releasing back to back updates to windows...
2014-08-18 (first published: 2014-08-12)
7,415 reads
MS14-044–Security Alert for SQL Server
I just saw this, but you should be aware. There’s a potential Denial of Service/Elevation of Privilege bug in SQL...
2014-08-12
767 reads
Modern Data Warehousing Presentation
I will be presenting the session “Modern Data Warehousing” tomorrow (Wednesday, August 13th) at the Central New Jersey SQL User...
2014-08-12
644 reads
T-SQL Tuesday #57 – SQL Family and Community
Look at that, it is once again that time of the month that has come to be known as TSQL Tuesday. TSQL Tuesday is a recurring blog party that...
2014-08-12
8 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