How to work with ChatGPT in Visual Studio Code
Learn how you can connect ChatGPT to VS Code and use it to help you fix your code.
2023-04-10
68,445 reads
Learn how you can connect ChatGPT to VS Code and use it to help you fix your code.
2023-04-10
68,445 reads
See how well ChatGPT works with questions on generating PowerShell code.
2023-03-20
14,384 reads
Introduction ChatGPT in SQL Server In this article, we will learn some basic examples of ChatGPT in SQL Server. In a previous article, we had an interview with ChatGPT an AI chatbot developed by OpenAI. If you do not know how to use it yet, you can go to that article. We will show some […]
2023-03-06
50,841 reads
ChatGPT is in a lot of media as an artificial intelligence program that might change the world. Will it change the world for developers?
2023-02-27
641 reads
As I looking at the feed of technology stories this week, two things jumped out at me. First, Valentine's day happened to fall on the monthly release day for Microsoft updates and feature previews. If you work with Azure services, specifically in the data platform space, there are a lot of update announcements to work […]
2023-02-18
208 reads
An interesting conversation with the ChatGPT artif...
2023-02-13
13,355 reads
2023-02-06 (first published: 2023-02-01)
3,820 reads
One place where Artificial Intelligence systems might shine is the medical field.
2022-08-03
185 reads
I found this article to be an interesting look at how we might add ethics to AI systems in one area. As the article points out, "... today there is no broadly accepted AI ethics framework, or means to enforce it. Clearly, ethical AI is a broad topic ...". Glad someone is thinking, or many […]
2022-07-25
140 reads
2021-11-24
272 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...
Comments posted to this topic are about the item Risk Vs Reward, The never...
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