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

How to replace given values with null using nullif()?

923

What new data source types were added in ssrs 2014?

153

How to restore performance issues and how to check?

1948

How to use subqueries with the exists operators in ms sql server?

1058

How does index makes search faster?

919

Explain about Normalization?

1012

Can you please differentiate between a primary key and a unique key?

949

What is the purpose of the model database?

962

What is the purpose of object explorer and its features? : sql server management studio

1121

What functions can a view be used to performed?

995

What is implicit mode in sql server?

1027

What is a data source or ds? : sql server analysis services, ssas

947

Do you know what is blocking?

899

List some of the rules that apply to creating and using a ‘view’

814

How to find table changes in sql server?

1049