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 call a function from a stored procedure in SQL Server ?

542

How secure is sql server database?

521

Explain how to send email from sql database?

554

Why would you use sql agent?

725

Explain what is the purpose of sql profiler in sql server?

546

Explain temporary table vs table variable by using cursor alternative?

515

List all types of constraints in sql server?

511

Can I disable or restrict ssrs export formats (rendering formats)?

108

what are the new features in SSRS?

104

What is the process of normalising?

582

How do I schedule a sql server profiler trace?

536

What is the datatype of rowid?

503

What are the indexes in sql server?

496

Difference between group by clause and having clause in SQL?

562

What is table constraint?

539