sql server select rows into string

Question

I have the following query.

declare @column_names varchar(1000)    
declare @result varchar(1000)

set @column_names='id,firstname,lastname,age,city,country'
set @result=''
select @result=@result+@column_names +','+from studenttable where id='1'

But this query returns id,firstname,lastname,age,city,country as result and not like 1,john,j,21,newyork,us.

How to change query so that @result will contain actual entries in comma-separated form?

Please reply. Thanks.

You will have to use dynamic sql - mssqltips.com/sqlservertip/1160/… — Bobby
– Bobby, Commented Jun 4, 2014 at 7:08

Deepshikha · Accepted Answer · 2014-06-04 07:10:55Z

2

To execute dynamic T-SQL statements use sp_executesql as:

EXECUTE sp_executesql 
          N'SELECT ' +@column_names +' FROM studenttable 
          WHERE id= @id',
          N'@id tinyint',
          @id= 1;

answered Jun 4, 2014 at 7:10

Deepshikha

10.3k2 gold badges24 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

sql server select rows into string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related