How to store a single quote in sql variable

Question

Declare @qt varchar(5)
Declare @xmlt xml
 set @qt = '''

I am unable to store a single quote in a variable, I need to concatenate before and after a column like below

update #TEMP_TABLE2
set XMLDatat =CONCAT(@qt,@xmlt,@qt)

So i have a single quote before and after the column

Have u tried `set @qt = ''''` ? – Yogesh Sharma Mar 20 '18 at 06:33 — Yogesh Sharma, Mar 20 '18 at 06:33
@Kumar Which MS SQl server version you are using – Alfaiz Ahmed Mar 20 '18 at 06:36 — Alfaiz Ahmed, Mar 20 '18 at 06:36
@YogeshSharma I have tried and single quote getting stored – Kumar Mar 20 '18 at 06:44 — Kumar, Mar 20 '18 at 06:44
@AlfaizAhmed I am using MS sql server 2014 – Kumar Mar 20 '18 at 06:45 — Kumar, Mar 20 '18 at 06:45

score 0 · Answer 1 · answered Mar 20 '18 at 06:53

0

You can try the following query.

Declare @qt varchar(5)
Declare @xmlt xml
SET @qt = ''''
SET @xmlt ='Sample XML'

UPDATE #TEMP_TABLE2
SET XMLDatat = CONCAT(@qt,CAST(@xmlt AS VARCHAR(MAX)),@qt)

Thanks.

answered Mar 20 '18 at 06:53

Emdad

822
7
14

How to store a single quote in sql variable

1 Answers1