In order to construct xml data, we can use XmlElement, XmlAgg and XmlForest Oracle SQL functions. For more details, please see Oracle SQL/XML functions ...

Technical documentation for Microsoft SQL Server, tools such as SQL Server Management Studio (SSMS) , SQL Server Data Tools (SSDT) etc. - MicrosoftDocs/sql-docs ...

I blogged previously on the ease of use of GroovySql , which is Groovy 's easy-to-use JDBC -based data access approach.

Since XML is now a full-fledged datatype in SQL Server, you can easily create a new table that contains a field having XML in it, using the SQL Server Management Studio (formerly, Enterprise Manager).

This blog will show you how to create an xml from sql query having sql data. Write down the followng query to generate xml:- ...

Loosely-coupled, distributed system architectures need to be flexible enough to allow individual components to join or leave the heterogeneous conglomerate of services and components and to change ...

XML is often used to represent objects that expose different sets of properties. This "property bag" scenario is a prominent use case for the XML support added to Microsoft SQL Server 2005. However, ...

In this post, I want to cover how you can create a dacpac for SQL Server 2022 databases using sqlpackage. So that you keep the new SQL Server 2022 compatibility level when you deploy new databases.