I'm trying to run this simple UPDATE statement on a SQL Server 2012 and I keep getting an error that reads:
Msg 102, Level 15, State 1, Procedure category_UTrig, Line 9
Incorrect syntax near '44446'.
The statement is as follows:
"update category set CatConveyorStoreNumber=0
where CatConveyorStoreNumber is null"
The CatConveyorStoreNumber is a SmallInt field.
The database that I'm trying to modify came from a SQL server 2008, where it runs without any problems.