Strange SQL Update Issue
Posted on 2015-02-11
I am trying to run a simple update statement on a database. Here is the update:
SET tkprbudget.TBBudHrsWrk = '2'
WHERE tbemp = '130' and tbprdyear = '2015' and TBPrdNbr = '1'
When I run it I get these errors:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '+'.
Msg 208, Level 16, State 0, Line 1
Invalid object name '##XML'.
I have no clue what this is talking about. There is no + sign and I dont know what object ##XML is referring to either. Am I missing something obvious here? This is SQL 2012. Thank you for your help.