set @s= '' select @s=@s+column +',' if Len(@s)>0

how we can store the value like that 001,003,023 etc in sql
server 2005

Question Posted / achuthan

Answer Posted / achuthan

set @s= ''
select @s=@s+column +','
if Len(@s)>0
select @s = substring(@s,1,len(@s)-1)

Is This Answer Correct ?

0 Yes

6 No

Please Help Members By Posting Answers For Below Questions

what method you can use to reduce the overhead of Reporting Services data sources?

255

Explain tablesample?

1002

What is sql server locking?

996

Explain powershell included in sql server 2008?

1065

Can two tables share the same primary key?

938

How can I get data from a database on another server?

1001

What is truncate table?

947

Explain nested join?

989

Give main differences between "Truncate" and "Delete".

1101

What is service broker?

1008

Is sql server free?

921

Can you move the resources after pausing the node? : sql server database administration

1111

What are different types of schemas?

947

What is the syntax to execute the sys.dm_db_missing_index_details?

1030

What are audit control procedures?

995