have table with two columns with datatypes as number and
varchar and the values in
A column like 1,2,3 AND B column values like a,b,c.
now need to display data in a single column as 1,a,2,b,3,c.
Answer Posted / saravanan
Try this way!
create table stest(num int,name varchar(10),value numeric
(10,2));
insert into stest values(101,'SARAN',1000.58);
insert into stest values(102,'KALA',1200.18);
insert into stest values(103,'AYYA',3000.40);
insert into stest values(104,'RATNA',4000.57);
SELECT * FROM STEST;
declare @str varchar(2000);
set @str = null;
select @str=ISNULL(@str+',','')+ltrim(STR(num))+','+name
from stest
select @str;
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is the most common sql injection tool?
What is linq to sql?
When are we going to use truncate and delete?
What are the advantages of stored procedure?
What is sql basics?
Why do we use procedures in pl sql?
What language is oracle sql developer?
Does sql*plus also have a pl/sql engine?
What is sql*loader and what is it used for? : aql loader
Describe sql comments?
What is on delete set null?
Is merge a dml statement?
What is the difference between the conventional and direct path loads? : aql loader
What port does sql server use?
What are the different tcl commands in sql?