SQL SERVER QUOTENAME String Function

SQL SERVER QUOTENAME String Function

QUOTENAME String function adds a delimiter to a String .

EX: Add SQL-SERVER DEFAULT DEMILITER FOR QUOTEs I.E '['

select 'swamy vivekanda says:'+quotename('strenth is life,weekness is death')

o/p:

swamy vivekanda says:[strenth is life,weekness is death]

Ex: QUOTENAME delimiter "

select 'swamy vivekanda says:'+quotename('strenth is life,weekness is death','''') quotename

O/P:
quotename
swamy vivekanda says:'strenth is life,weekness is death'

select 'swamy vivekanda says:'+quotename('strenth is life,weekness is death','"') quotename

O/P:
quotename
swamy vivekanda says:"strenth is life,weekness is death"


Tags:SQL SERVER QUOTENAME String Function,QUOTENAME DELIMITER,QUOTENAME DEMILITER ' ,SQL SERVer QUOTENAME NAME ESCAPE CHARACTERS