Solution: "Data Types varchar and bit are not compatible with the Add operator"

In SQL 2005, "varchar and bit of the data type are not compatible with the Add operator" only need to use the convert () function.

To convert a bit variable @ num to the varchar type: Convert (varchar (4), @ num ).

Create procedure [DBO]. [sp_news_deletecategory1]
@ Categoryid nvarchar (160 ),
@ Isdeleted bit
As

Begin
Declare @ SQL nvarchar (260)
Set @ SQL = 'Update news_categories set isdeleted = '+ convert (varchar (4), @ isdeleted) + 'where categoryid in (' + @ categoryid + ')'
-- Print @ SQL
Execute (@ SQL)
End

Note: The application isInCommand.