SQL multiple update
- skarbnik
- Nov 4, 2015
- 1 min read
UPDATE [dbo].[TBL_IVR_CUSTOMERS]
SET
[TXT_SPECIAL_TRANSFER_MODUL_NUM] = 'B100.1.1-B310400,B100.2.4.3-B310400,B120.2.1.3-B315028,BD120.2.1.3-B315028,B120.2.2.4-B314020,BD120.2.2.4-B314020,B120.2.3.3-B314020,BD120.2.3.3-B314020,'
where [NUM_ACCOUNT_NUM] in ('61222980','61246395','61236924','61238189','8081844','60991194','61243846','40300728','61243387','61198172')
Comments