collation dari tabel di db1 beda dengan tabel di db2
tergantung dari collation pada salah satu dari database yg dibandingkan, coba tambahkan COLLATE pada query, misalnya:
select * from DB1..Table1
inner join DB2..Table2 on DB1..Table1.fild1 = DB2..Table2.fild2 collate SQL_Latin1_General_CP1_CI_AS
menampilkan collation dari suatu tabel: exec sp_tablecollations <nama_tabel>
untuk mengetahui lebih lanjut tentang collation, baca manual sql server
Blog seputar pemrograman terutama Delphi, database, software, IT, dan lain-lain yang merupakan pengalaman pribadiku.
http://rudycs.blogspot.com.
--- On Fri, 6/26/09, hari_kita <hari_kita@yahoo.com> wrote:
From: hari_kita <hari_kita@yahoo.com>
Subject: [ITCENTER] mohon petunjut menghubungkan 2 tabel didalam database berbeda
To: ITCENTER@yahoogroups.com
Date: Friday, June 26, 2009, 1:47 AM
dear all
plizz help me.. kalau aku ingin menjoin kan dua tablel tapi beda database di database sql server 2000
kok selalu muncul error
Msg 446, Level 16, State 9, Line 1
Cannot resolve collation conflict for not equal to operation.
contoh :
select * from DB1..Table1
inner join DB2..Table2 on DB1..Table1. fild1 = DB2..Table2. fild2
makasih ya..
-hari-
[Non-text portions of this message have been removed]
------------------------------------
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Gabung, Keluar, Mode Kirim : itcenter-help@yahoogroups.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:ITCENTER-digest@yahoogroups.com
mailto:ITCENTER-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
ITCENTER-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
0 komentar
Posting Komentar