UPDATE tblbarang SET
harga_beli =
CAST(NULLIF([harga_jual],'') AS decimal(13,0)) - CAST(NULLIF([rabat_nominal],'') AS decimal(13,0))
WHERE harga_beli=harga_jual
harga_beli =
CAST(NULLIF([harga_jual],'') AS decimal(13,0)) - CAST(NULLIF([rabat_nominal],'') AS decimal(13,0))
WHERE harga_beli=harga_jual
Cara menjumlahkan nilai varchar ke decimal query MSSQL
![Cara menjumlahkan nilai varchar ke decimal query MSSQL]()
Reviewed by Syawaluddin Amin, S.Kom
on
Desember 21, 2015
Rating:
![Cara mengatasi error microsoft excel style 'comma [0]' not found](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOFi0vZX0Si_GfPTRMx9sV-xbrBAfxPv3hwRBnI_wXXHpVWuLXE-OEbztMvyCJDcn1Lt9iCfluqm2_q_cviCxFKjHMj6DgyTzYgzF5pFB_McNqh-vQuKZAVenkPpYa23kOvNlivVY7LjgU/s72-w618-c-h323/Screenshot_0.png "Cara mengatasi error microsoft excel style 'comma [0]' not found")
Tidak ada komentar: