Spaces in Object Names Revisited
I think in general the SQL Server DBA’s of the world prefer that object names not have spaces embedded, and...
2009-10-05
833 reads
I think in general the SQL Server DBA’s of the world prefer that object names not have spaces embedded, and...
2009-10-05
833 reads
Over the past few years we’ve had a number of recruiters and staffing firms visit oPASS as sponsors, and we...
2009-10-04
362 reads
You can read the full text of it in today’s SSC Newsletter, the quick summary is that for many businesses...
2009-10-02
260 reads
It was nice to work through my email and find a bit of positive news instead of more work! I’m...
2009-10-02
399 reads
There are lots of technical people that are forced to be DBAs by necessity. However there is another class of DBAs, the Incidental DBAs. Andy Warren brings a guest editorial that reminds us about this group of people that work with SQL Server.
2009-10-02
201 reads
In this case making money is about counterfeiting. The Art of Making Money: The Story of a Master Counterfeiter ($18)...
2009-10-01
397 reads
I try not to post too many links without some thoughtful commentary, but I ran across this and thought it...
2009-10-01
277 reads
I’ve had the glimmer of this idea since I posted about the idea of bringing my chair to the 2009...
2009-09-30
1,391 reads
Hopefully you saw it in the special mailing that went out yesterday, but the marketing team just released a new...
2009-09-30
1,375 reads
We’re closing in on our October 17th SQLSaturday #21 in Orlando and I thought I’d share a few things about...
2009-09-30
1,408 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...
Telp/Wa 628218200203 Jl. Batu Ceper No.18 A-B, RT.1/RW.2, Kb. Klp., Kecamatan Gambir, Kota Jakarta...
Telp/Wa 628218200233 Komplek Apartemen Grand Kartini, Ruko. 18, Jl. Kartini Raya No.57, RT.3/RW.2, Kartini,...
Telp/Wa 628217555651 Wisma 46 Lantai Dasar, Jln. Jend. Sudirman Kav. 1, RT.5/RW.3, Senayan, Kec....
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