declare @tb table (id char(10), shipid char(10), test char(10)) insert @tb SELECT '1001', '223', '12312' UNION ALL SELECT '1002', '12', '123' UNION ALL SELECT '1003', '444', '213' UNION ALL SELECT '1004', '123', '123' select 'B100'+id as id, shipid, test from @tb /* id shipid test -------------- ---------- ---------- B1001001 223 12312 B1001002 12 123 B1001003 444 213 B1001004 123 123 */
chuifengde 你的方法我用过 说要截断二进制 需要一条更新语句
select 'B100'+cast(id as varchar(100)) , shipid, test from @tb
declare @tb table (id char(10), shipid char(10), test char(10))
insert @tb
SELECT '1001', '223', '12312' UNION ALL
SELECT '1002', '12', '123' UNION ALL
SELECT '1003', '444', '213' UNION ALL
SELECT '1004', '123', '123'
select 'B100'+id as id, shipid, test from @tb
/*
id shipid test
-------------- ---------- ----------
B1001001 223 12312
B1001002 12 123
B1001003 444 213
B1001004 123 123 */
select 'B100'+cast(id as varchar(100)) , shipid, test from @tb
select id=('B100'+id),shipid ,test from tb