the multi-part identifier could not be bound error saat update table


saya mau update field remark1 di table do dengan field remark1 di table so dengan perintah :

update DO set d.remark1=s.Remark1 from Do d join SO s on d.Dockey=s.ToDocKey

tetapi saat dijalankan muncul pesan anda belum beruntung:

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier “d.remark1” could not be bound.

 

setelah cari mencari, akhirnya ditemukan cara :

update DO set remark1=s.Remark1 from ( select ToDocKey,Remark1 from SO ) s where DocKey=s.ToDocKey and (do.remark1<>” or do.remark1 is not null)

 

dan Alhamdulillaah ini berjalan dengan baik dan benar🙂

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s

%d blogger menyukai ini: