PASS Summit – Last Chance for Discounted Rate
Through tomorrow you can register for the very discounted rate of $1395 – details at http://summit2009.sqlpass.org. Historically we see a surge...
2009-09-14
635 reads
Through tomorrow you can register for the very discounted rate of $1395 – details at http://summit2009.sqlpass.org. Historically we see a surge...
2009-09-14
635 reads
We’ve got a great meeting coming up with Todd Holmes doing a mini presentation on Backup Basics, followed by Jorge...
2009-09-13
240 reads
I’ve been on the board just about 8-1/2 months, so I’m not doing too bad on updates, but think I’ll...
2009-09-13
951 reads
I glance at Make (magazine and web site) from time to time, and recently have been recording and watching their...
2009-09-10
811 reads
My friend Don Gabor is providing us with some tips on networking as related to both PASS and the PASS...
2009-09-10
226 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-09-10
845 reads
I taught myself programming with Quick Basic (started with Turbo Basic but couldn’t find a book on it, so bought...
2009-09-09
376 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-09-08
718 reads
It’s been a couple months since we set up the OPASS group on LinkedIN and we’ve had some people join,...
2009-09-07
299 reads
The next Tampa Code Camp will be Nov 7th, 2009 at the KForce Building in Tampa. For the first time...
2009-09-06
314 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