In an XML structure, the multiplicity of a node defines how many times that node can appear. In the following example the data from 4 columns in one row in a table will be exported in a XML node with multiplicity of 4. Two metho...

In an XML structure, the multiplicity of a node defines how many times that node can appear. In the following example the data from 4 columns in one row in a table will be exported in a XML node with multiplicity of 4. Two methods of export will be show...

This is a temporary post that was not deleted. Please delete this manually. (49480628-4f16-4dc6-9eda-51d45a9f0fe3 - 3bfe001a-32de-4114-a6b4-4005b770f6d7)......

It is a poor programming practice to use SELECT * when defining a view because: it is not clearly defining the columns, you have to select from the view or inspect the underling tables to see the columns and their type......

It is a poor programming practice to use SELECT * when defining a view because:- it is not clearly defining the columns, you have to select from the view or inspect the underling tables to see the columns and their type- it can be damaging for performan...

Extracting integers from strings - The post explains how we can use regular expressions to extract integers from strings in TSQL....

Usually, if we have to extract numbers from a string, in any programming language, the first idea is to use regular expressions. How could we use regular expressions to extract integers from strings in TSQL? Let’s suppose we have a table with a s...