Database
-
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 –…
-
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…
-
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…