27,579
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([A01] nvarchar(22),[A02] int,[A03] nvarchar(27),[A04] int)
Insert #T
select N'长A',500,N'(长A)-10',0 union all
select N'长B',600,N'(宽A)-10',0 union all
select N'宽A',700,N'(长B)-20',0 union all
select N'宽B',800,N'(宽A)-20',0
Go
--测试数据结束
UPDATE #T
SET A04 =
(
SELECT TOP 1 A02 FROM #T a WHERE CHARINDEX('(' + a.A01 + ')', #T.A03) > 0
) + CONVERT(INT, SUBSTRING(A03, CHARINDEX(')', A03)+1, LEN(A03) - CHARINDEX(')', A03)));
SELECT * FROM #T