Lab Sql

I'm passing Sql Staments from Ms sql server to Sap Hana Sintaxis (There are inside an xml file)… Read more Greater Than Operator > In Hana

I need to order attribute names in alphabetic order and I've created following code, but it lef… Read more Order Attribute Names In Xml Using T-sql

How to change my query so that this error doesn't happen: XML data type method “value” must b… Read more Xml Data Type Method “value” Must Be A String Literal

In below Hive-query, I need to read the null / empty 'string' tags as well, from the XML co… Read more In Hive, How To Read Through Null / Empty Tags Present Within An Xml Using Explode(xpath(..)) Function?

I tried to serialize a DataTable object to xml. The DataTable has a column with type 'geography… Read more Datatable With Sqlgeography Column Can't Be Serialized To Xml Correctly With Loss Of Lat,long And Other Elements

I'm pretty new to using XML with TSQL, and recently ran into an issue that I can't think ar… Read more Open Xml Document And Return For Every Row, Based On Row's Path To Xml File

I'm trying to import data from a XML file into a database. I've made a test script using BU… Read more Import Xml File Into Sql Server Without Bulk

I have MS SQL table which contains a XML type field. This field has data in the format below: AA … Read more Getting Values From Xml Type Field Using In Sql Server