the SQL statements in the qry is
Select * from table
Where a=: a
A database of type varchar (6)
Program here, my machine compiled to
The exec sp_executesql N 'select *
From the table
Where a=@ P1
', N '@ P1 text ','
Executes an error, data type varchar and text in equal to the operator in the incompatible
But another machine compiled is normal,
Another machine compiled to
The exec sp_executesql N 'select *
From the table
Where a=@ P1
', N '@ P1 varchar (6) ', '
'
The program is running normally,
Excuse me, is something wrong with my compiler? Why the null value defaults to the TEXT? How should change?
Thank you,
