Microsoft SQL Server Abbreviations

XMLA stands for XML for Analysis

XMLA stands for XML for Analysis stands for Extensible Mark-up Language for Analysis. It’s a language built on top of XML language. It allows data access from standard multidimensional data sources. Client applications accesses Microsoft cubes and tabular models using the XMLA language and the HTTP protocol. XMLA stands for

SQL Server Errors

SQL Server error conversion from XML to NVARCHAR

How to convert XML into NVARCHAR with SQL Server? To avoid the SQL Server error conversion from XML to NVARCHAR. The exact message is “Implicit conversion from data type xml to nvarchar is not allowed. Use the CONVERT function to run this query.”. With SQL Server data, it is useful

SQL Server Strings

How to split a delimited text in SQL Server?

How to split a delimited text in SQL Server? The string to split can have a comma or a semicolon delimiter. Using an SQL Server query, you can cut a string compounded of text, delimited by commas, semicolons, tabulations, dash, underscore, or even dots. It can basically be any character