Justin Cooney – Web Development Tips and Examples

Tech and programming information about topics of interest or issues that I find noteworthy. Many of these posts are notes for myself although I am happy if they are useful to others.

Asking Copilot to Generate SQL with Data from a Specific Web Site as a Source

In a previous post I looked at getting MS Copilot to generate a tSQL code snippet to get a list of countries and their GDP and to insert this into a SQL Server temporary table variable. Here is the post: Using MS Copilot to Generate SQL Server Code to List Countries and their GDP –…

2024-01-01

Justin Cooney

Database, MS Copilot, Programming, SQL, SQL Server, SQL Tips
Using MS Copilot to Generate SQL Server Code to List Countries and their GDP

MS Copilot (formerly known as Bing Chat with GPT-4) can be useful not just for generating funny images and random trivia, but for actual, useful code snippets. I’ve been playing around with this to see what it can do and what kind of prompts it takes to get the code that I want. For this…

2023-12-31

Justin Cooney

Database, MS Copilot, Programming, SQL Server

ai, artificial-intelligence, copilot, github, microsoft
SQL Server Search Through XML Rows Stored in a Table Column

There might come a day where you need to query a SQL Server table that has embedded XML rows. This is basically like having a table inside of a table. A simple example of where you might find this is in historical logging. So for example this might be a historical table where each day…

2023-11-15

Justin Cooney

Database, Programming, SQL, SQL Server, SQL Server 2022, SQL Tips, Transact-SQL, tSQL