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 is mapping schema?

770

How many types of stored procedures are there in sql server?

735

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

732

Define compound operators?

680

What is Transparent Data Encryption?

734

How connect excel to sql server?

685

What is hot add cpu in sql server 2008?

702

What is the cartesian product of table?

731

Why would you call update statistics?

758

How to list all triggers in the database with sys.triggers in ms sql server?

751

Which sql server table is used to hold the stored procedure scripts?

801

How do indexes help, types?

718

Explain an incremental backup?

752

Find columns used in stored procedure?

704

State the difference between local and global temporary tables?

796