SQL Server 方式
|
1 |
UPDATE bd_cubasdoc SET custcode = '0'+SUBSTRING(custcode,0,99) WHERE pk_areacl = '0001661000000000SMBV' |
Oracle 方式
|
1 |
update bd_cubasdoc SET custcode='0'||substr(custcode,0); |
SQL Server 方式
|
1 |
UPDATE bd_cubasdoc SET custcode = '0'+SUBSTRING(custcode,0,99) WHERE pk_areacl = '0001661000000000SMBV' |
Oracle 方式
|
1 |
update bd_cubasdoc SET custcode='0'||substr(custcode,0); |
Comment