Today I had a unique scenario where I had to introduce 2 spaces in between two fields.
I came across the space function which I used in my scenario.
The syntax is space(integer_expression)
The integer expression is an integer. IF a negative value is supplied a null is returned.
So for example look at the following syntax:
select First_name, + space(4) + Last_Name from test_table
The above select statement will generate 4 spaces in between the first name and last name
The space function will generate a miximum of 8000 spaces.
For more information click here
On 1st September 2018, I had a wonderful opportunity presenting at the SQL Saturday Auckland event at UNITEC. The title of my session was G...
This morning I was trying to call a stored procedure and insert the results in a temp table using the following code -- create table #...
Did you ever have a situation where you felt like converting a Sql Server Analysis Services in Multidimensional Mode to Tabular Mode ? ...