select cast([字段1] as varchar)+cast([字段2] as varchar)+([字段3] as varchar)+([字段n] as varchar) as 新字段 from 表
如果要增加的话,那么你生成一个新表好了,但是有可能要损失约束键select *,cast([字段1] as varchar)+cast([字段2] as varchar)+([字段3] as varchar)+([字段n] as varchar) as 新字段 into 新表名 from 原表drop table 原表
--测试代码 declare @tb1 table ( id int, col1 char(10), col2 char(10) )select *,cast([col1] as varchar)+cast([col2] as varchar) as col_new into #tb from @tb1 select * from #tb /* --测试结果id col1 col2 col_new ----------- ---------- ---------- --------------- */
update table_name set last_col= cast([字段1] as varchar)+cast([字段2] as varchar)+([字段3] as varchar)+([字段n] as varchar)
declare @tb1 table
(
id int,
col1 char(10),
col2 char(10)
)select *,cast([col1] as varchar)+cast([col2] as varchar) as col_new into #tb from @tb1
select * from #tb
/*
--测试结果id col1 col2 col_new
----------- ---------- ---------- ---------------
*/
set last_col= cast([字段1] as varchar)+cast([字段2] as varchar)+([字段3] as varchar)+([字段n] as varchar)