how we can store the value like that 001,003,023 etc in sql
server 2005
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 |
Post New Answer View All Answers
How to replace given values with null using nullif()?
What new data source types were added in ssrs 2014?
How to restore performance issues and how to check?
How to use subqueries with the exists operators in ms sql server?
How does index makes search faster?
Explain about Normalization?
Can you please differentiate between a primary key and a unique key?
What is the purpose of the model database?
What is the purpose of object explorer and its features? : sql server management studio
What functions can a view be used to performed?
What is implicit mode in sql server?
What is a data source or ds? : sql server analysis services, ssas
Do you know what is blocking?
List some of the rules that apply to creating and using a ‘view’
How to find table changes in sql server?