Re: can U solve my problems?

"Bpk. Adi Wira Kusuma" <adi_wira_kusuma@xxxxxxxxxxxx> wrote in message
news:42ba8e61@xxxxxxxxxxxxxxxxxxxxxxxxx
>I execute this syntax in Query Analyzer.
>
> SELECT * FROM TB1
> WHERE NO_ID IN (SELECT NOID FROM TB2)
>
> In the past, I always executed this syntax, and it's ok. But now, I get
> error message:
>
> Server: Msg 446, Level 16, State 9, Line 1
> Cannot resolve collation conflict for equal to operation.
>
> Why is it happended? And how to solve its problem?
>

My best guess is that the tables involved (or the fields) have a different
collation. If this is not the case, then probably the tempDB has a different
collation than your userDB. Lookup COLLATE in bol.

Maurice


.

Relevant Pages

  • can U solve my problems?
    ... I execute this syntax in Query Analyzer. ... WHERE NO_ID IN (SELECT NOID FROM TB2) ... In the past, I always executed this syntax, and it's ok. ...
    (borland.public.delphi.database.ado)
  • Re: Waveform Mini-Language
    ... The syntax might seem strange at first, ... Got any ideas for how to make a "go" command ... How about "Frequency 500 Hz Voltage 20 Volts Set"? ... Frequency would error check and execute it. ...
    (comp.arch.embedded)
  • Re: different patching syntax
    ... other patches as time goes. ... Wscript.Echo "Syntax Error. ... 'execute each files ... Is this the whole script as shown on this ...
    (microsoft.public.windows.server.scripting)
  • Re: If you got to choose the syntax, what would you do?
    ... from one computer to another and get them to execute what syntax would ... This is the simple 'remote execute' problem. ... This is sufficient to let the host examine target memory, ...
    (comp.lang.forth)
  • RE: Insert Code Not Working
    ... error is because you did not use the dbFailOnError option. ... Dim strSQL As String ... You can execute it straight from the Execute without first putting it in a ... but first putting it in a string ensures you have the syntax correct ...
    (microsoft.public.access.formscoding)