How to select empty string using sp_executesql?

Question

I am trying select empty string using sp_executesql. Here is my SQL

declare @query nvarchar(MAX)
set @query = 'SELECT '+'\''\'+' AS Name'
EXECUTE sp_executesql @query

I want to make select statement like below (normal sql statement), but using sp_executesql

SELECT '' AS Name

Escaping `'` is done by doubling it (`''`). T-SQL has no escape character. — Jeroen Mostert, May 08 '18 at 10:04
@JeroenMostert Can you give me sample code please. Is it not possible? — williamson smith, May 08 '18 at 10:06
@JeroenMostert I didn't get your point. Can you give me more explaination, Thanks — williamson smith, May 08 '18 at 10:09

score 0 · Answer 1 · answered May 08 '18 at 10:15

0

This is the answer, I hope it will help for someone

declare @query nvarchar(MAX) set @query = 'SELECT '''' AS Name' EXECUTE sp_executesql @query

answered May 08 '18 at 10:15

williamson smith

1 Answers1