Posted by coop on 12/20/05 23:58

I have a stored procedure that works fine on SQL Server 2000 or 2005,
but when run on an machine running MSDE, I get the Operand type clash,
int is incompatible with text data type error. The data type is
actually text and text is the type of data being passed. Any
parameters not being used are defaulted to null. Any ideas why this
would happen on MSDE and work fine anywhere else?

Thanks so much.

• Next in forum: Re: How do I use SELECT on a column with datatype TEXT?
• Prev in forum: Re: Getting data from multiple rows into one column
• Thread view: operand type clash

[Reply to this message]