<div>
You have a trigger after update or instead of update on [category] which is erroneous. So take a look at it.
</div>


You have a trigger after update or instead of update on [category] which is erroneous. So take a look at it.

<div>
<div class="content wysiwyg-content">
Hello all,<br />
<br />
I'm trying to run this simple UPDATE statement on a SQL Server 2012 and I keep getting an error that reads:<br />
<br />
Msg 102, Level 15, State 1, Procedure category_UTrig, Line 9<br />
Incorrect syntax near '44446'.<br />
<br />
<br />
The statement is as follows:<br />
<br />
&quot;update category set CatConveyorStoreNumber=0<br />
where CatConveyorStoreNumber is null&quot;<br />
<br />
The CatConveyorStoreNumber is a SmallInt field.<br />
<br />
The database that I'm trying to modify came from a SQL server 2008, where it runs without any problems.<br />
<br />
Any ideas?
</div>
</div>


Hello all,

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.

Any ideas?

SQL Server 2012 - Incorrect syntax near '44446'.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.