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 do you understand by recursive stored procedure?

986

How raid can influence database performance?

1084

State the difference between local and global temporary tables?

1166

Is sql server a database?

1040

How to enter comments in transact-sql statements?

987

Explain how many normalization forms?

1077

Explain a checkpoint?

1085

What are the disadvantages of using the stored procedures?

1186

Is port 1433 secure?

1038

What is the synonym of join?

1015

What are the types of indexing?

1117

What are out-of-range errors with date and time literals?

1094

What is database architecture? : SQL Server Architecture

1099

What do you do in data exploration

1050

What are the 3 types of schema?

1176