Wednesday, 5 July 2017

New function:Quotename


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'

 

No comments:

Post a Comment