String Concatenation in T-SQL

Question

I've to concatenate a sql query with a parameter. My t-sql code:

DECLARE @TESTPARAM varchar(20)
DECLARE @SQLQUERY varchar(250)
SET @TESTPARAM = 'test'
SET @SQLQUERY = 'SELECT ' + @TESTPARAM+ '

So I want to have the value in the select query and not the column.

Can you help me?

Thanks a lot.

Kind regards, pro

Hi sll what is not clear? I want to have the value test in my select statement - like this: select 'test' — bitsmuggler
– bitsmuggler, Commented Dec 29, 2011 at 10:35

Michał Powaga · Accepted Answer · 2011-12-29 10:35:47Z

3

Try:

DECLARE @TESTPARAM varchar(20)
DECLARE @SQLQUERY varchar(250)
SET @TESTPARAM = 'test'
SET @SQLQUERY = 'SELECT ''' + @TESTPARAM + ''''

answered Dec 29, 2011 at 10:35

Michał Powaga

23.4k8 gold badges55 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user359040 Over a year ago

@pro: Please remember to Accept answers that meet your requirements.

bitsmuggler Over a year ago

@Mark - I couldn't accept it within four minutes after I've voted for it. But now I've accepted it.

Gaspa79 · Accepted Answer · 2011-12-29 11:48:24Z

0

The single quote is an escape character for the single quote, that's why when you put '' in a string it will actually be stored as ' in your string, such as \\ in any C-syntax language =-). I thought I might add that.

answered Dec 29, 2011 at 11:48

Gaspa79

5,7166 gold badges44 silver badges66 bronze badges

Comments

Bill the Lizard · Accepted Answer · 2011-12-30 13:03:01Z

0

DECLARE @TESTPARAM varchar(200)
DECLARE @SQLQUERY varchar(250)
SET @TESTPARAM = 'test'
SET @SQLQUERY = 'SELECT ' +  @TESTPARAM 
SELECT @SQLQUERY

edited Dec 30, 2011 at 13:03

Bill the Lizard

407k213 gold badges579 silver badges892 bronze badges

answered Dec 30, 2011 at 13:00

praveen

1

1 Comment

bitsmuggler Over a year ago

Hi praveen, thanks for your code. unfortunately it's not the solution, because it is selected the following value: 'SELECT test' and I need 'Select 'test''.

Collectives™ on Stack Overflow

String Concatenation in T-SQL

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related