Representing XML data in SQL Server
In this article, we will see how to use the FOR XML statement in SQL Server to represent the result of queries in XML format.
2020-04-24 (first published: 2018-08-07)
5,401 reads
Diogo Castro
Blogs
Daily Coping 3 Dec 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQL Homework – December 2020 – Participate in the Advent of Code.
Christmas. Depending on where you live it’s a big deal even if you aren’t...
[Video] Azure SQL Database – Import a Database
By Arun Sirpal
Quick Video showing you have to use a BACPAC to “import” a database into...
Forums
Inflow / outflow report per day
Hello, I have two simple tables: Invoices InvoiceID Date Value and PaymentsReceived PaymentID Date...
If SQL Agent Job takes longer than @X minutes, get notified.
If Agent Job takes longer than @X minutes, we want to be notified. What...
Unable to create report in VS 2017
I have downloaded and installed Visual Studio 2017 and can connect to SQL Server...
Ask SSC