DEFINITIONS

Definitions More Info.
Definition ID900
TitlePOSTGRESQL
CategoryNOTES
Definitionilk 8 karakter string alan update etme
Definition DescriptionUPDATE "ERP"."AccountingTransactionItem"
SET "Description"='2018/09 '||SUBSTRING("Description",9,LENGTH("Description")-1)
WHERE LTRIM(RTRIM(SUBSTR("Description",1,8)))LIKE '%2018/08%'
AND "AccountingTransactionID"=2280203


SELECT '2018/09 '||SUBSTRING("Description",9,LENGTH("Description")-1)
FROM "AccountingTransactionItem"
WHERE "AccountingTransactionID"=2280203
AND "ID"=14188269
RecordBycunay
Record Date26-10-2018 14:13:28
Düzenle
Kopyala
Sil