asked
updation error
hi all, i am trying to update a table in sql server 2005 by using command, but when i am executing then i am getting the error msg 156. can any one help me out in this regarding.
Standard Syntax is UPDATE TABLE SET COLUMN_NAME = 'XXXX' WHERE CONDITION = 'YYYY'
i was using update table tablename which was throwing the error i used update tablename it worked. thanks
Your best bet is to head to the source and check out the examples: [Books OnLine - UPDATE][1] [1]:
http://msdn.microsoft.com/en-US/library/ms177523%28v=SQL.90%29.aspx
Sure looks like you're showing some type of ORM related set of code. XML like that is not standard SQL syntax. You'll need to troubleshoot this starting from your code. If you feel that's in hand, then you need to see what kind of TSQL your code is generating. Best way to do that is to fire up [SQL Profiler][1]. Do not run that on a production system though. [1]:
http://msdn.microsoft.com/en-us/library/aa173918(v=SQL.80).aspx
