表:
id name desc
1 aa 00
2 bb 99
3 cc 88得到为
id name desc id--name
1 aa 00 1--aa
2 bb 99 2--bb
3 cc 88 3--cc
id name desc
1 aa 00
2 bb 99
3 cc 88得到为
id name desc id--name
1 aa 00 1--aa
2 bb 99 2--bb
3 cc 88 3--cc
insert T select 1, 'aa', '00'
union all select 2, 'bb', '99'
union all select 3, 'cc', '88'
select *,[id--name]=cast(id as varchar)+'--'+[desc] from T--result
id name desc id--name
----------- ---- ---- ----------------------------------
1 aa 00 1--00
2 bb 99 2--99
3 cc 88 3--88(3 row(s) affected)
id name desc id--name
----------- ---- ---- ----------------------------------
1 aa 00 1--aa
2 bb 99 2--bb
3 cc 88 3--cc(3 row(s) affected)