QuoteName:
Today, we look at the new function in Sql server-2014 which is Quotename.
If you want to append any string with special characters like [,{,'...
then we will use the Quotename function. Below are the few examples.
Example 1:
Append '{' to 'abc'
select QUOTENAME ('abc','{')
Example 2:
Append '[' to 'abc'