--trycreate table tb(tname varchar(10),tspce varchar(10),tAmount int)insert into tb select 'WWW','0.8"',6
insert into tb select 'ZZZ','0.9"',3
insert into tb select 'FFF','1.2"',4select distinct ltrim(rtrim(tspce)) +'/'+cast(tAmount as varchar(10)) +'/'+ltrim(rtrim(tname)) result from tb/*
result
---------
0.8"/6/WWW
0.9"/3/ZZZ
1.2"/4/FFF*/
insert into tb select 'ZZZ','0.9"',3
insert into tb select 'FFF','1.2"',4select distinct ltrim(rtrim(tspce)) +'/'+cast(tAmount as varchar(10)) +'/'+ltrim(rtrim(tname)) result from tb/*
result
---------
0.8"/6/WWW
0.9"/3/ZZZ
1.2"/4/FFF*/
tName varchar(10),
tSpec varchar(10),
tAmount int
)insert into A
select 'WWW','0.8"',6 union all
select 'ZZZ','0.9"',3 union all
select 'FFF','1.2"',4select a=(tSpec+'/'+ltrim(tAmount)+'/'+tName) from Adrop table A
--这样?
create table tb(tname varchar(10),tspce varchar(10),tAmount int)insert into tb select 'WWW','0.8"',6
insert into tb select 'ZZZ','0.9"',3
insert into tb select 'FFF','1.2"',4declare @sql varchar(8000)
set @sql = 'select distinct '
select @sql = @sql+'ltrim(rtrim(tspce)) +''/''+cast(tAmount as varchar(10)) +''/''+ltrim(rtrim(tname)) result'
set @sql= @sql +' from tb'
exec(@sql)
--select distinct ltrim(rtrim(tspce)) +'/'+cast(tAmount as varchar(10)) +'/'+ltrim(rtrim(tname)) result from tb
/*
result
---------
0.8"/6/WWW
0.9"/3/ZZZ
1.2"/4/FFF*/
create table tb(tname varchar(10),tspce varchar(10),tAmount int)
insert into tb select 'WWW','0.8"',6
insert into tb select 'ZZZ','0.9"',3
insert into tb select 'FFF','1.2"',4declare @sql varchar(8000)
select @sql=isnull(@sql+char(13),'')+tspce+'/'+ltrim(tamount)+'/'+tname from tb
print @sql