January 2, 2013 at 5:53 am
ERROR:The data types varchar and bit are incompatible in the add operator.
CAN ANY ONE KNOW WHAT TYPE OF ERROR IS THIS
CAN U FIND IT PLS
January 2, 2013 at 5:57 am
You cant add a bit to a varchar or a varchar to a bit.
What are you trying to do, string concatenation?
Please provide details of your task at hand.
January 2, 2013 at 6:39 am
You'll have to CAST one of the data types to one or the other in order to combine them.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 2, 2013 at 6:48 am
lathish2kumar (1/2/2013)
ERROR:The data types varchar and bit are incompatible in the add operator.CAN ANY ONE KNOW WHAT TYPE OF ERROR IS THIS
CAN U FIND IT PLS
It is in your code, which you didn't post. Hard to help you find it when we can't see it. Also, please use your inside voice, there is no need to yell. (In other words, drop the typing in ALL CAPS.)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply