Massimiliano Figini
Only My Notes

Only My Notes

Blog Author Picture

Massimiliano Figini

13 followers

data engineer • T-SQL developer • r and python • Power BI and tableau machine learning enthusiast • data lover

XML documents in SQL Server and Azure SQL Database

Feb 27, 20224 min read

1. XML documents in SQL Server and Azure SQL Database While JSON uses nvarchar type, XML has a dedicated column type of the same name in SQL Server and Azure SQL Database. -- Create table and insert data for the examples CREATE TABLE [dbo].[XMLexampl...