|
|
-
|
|
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 shown, both use FOR XML clause and the second will ......
|
|
-
|
|
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 performance to allways return all the rows when maybe yo......
|
|
-
|
|
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 string column in which we can have letters and n......
|
|