June 24, 2002 at 1:46 am
Hi friends
I have tried the following query in sql2000
and sql 7 databases. But the query working fine in sql 7 and giveing error message in
sql 2000. What may be the reason ?. The structure of table is same in both database.
Query in sql 7
select a.cname from debitor a ,anotherdatabase..debitor b
where b.ktonr = a.kunnr
This query gives results.
Query in sql 2000
select a.cname from debitor a ,anotherdatabase..debitor b
where b.ktonr = a.kunnr
this give gollowing error message
Cannot resolve collation conflict for equal to operation.
????
Regards
Joseph
June 25, 2002 at 4:39 am
Right click the databae in SQL 2000 in EM and choose properties. Verify on the General tab at the bottom that the collations for the database is the same. If is then right click and choose copy on the tables in question and post into QA, there you can easily see the column level collation, make sure the 2 joining columns have a cpatible collation.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 27, 2002 at 6:31 am
you are right
The collation construct of both databses are not same.
one database have the construct "SQL_Latin1_General_CP1_CI_AS"
and another having "Latin1_General_CI_AS"
How we can change this contruct ?
B.regards
Joseph
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply