Home Forums SQL Server 2008 T-SQL (SS2K8) Update linked server RE: Update linked server
HanShi
SSC-Dedicated
Points: 33506
More actions
June 26, 2013 at 2:13 am
#1627417
I think it is related to the datatype of the variable. If the columntype is INT the variable must be implicitly converted from the VARCHAR type.
If the value is always a number, why have you declared it as a VARCHAR and not as an INT?