can U solve my problems?

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?


.

Relevant Pages

  • 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)
  • Re: Syntax Check
    ... parse the statement; binding won't happen, so you won't get errors that are ... not related to syntax such as invalid table names. ... "Cathie Hagen" wrote in message ... >> execute something for real. ...
    (microsoft.public.dotnet.framework.adonet)