An expression of non-boolean type specified in a context where a condition is expected, near 'Id',in SQL Server2005
I am new to ADO.net and SQL Serve开发者_如何学Pythonr 2005.
I created one table TABLE1
with id(pk),name,group
and I am trying to update using
UPDATE TABLE1 SET name="stack" where id=2
then it giving bellow error
An expression of non-boolean type specified in a context where a condition is expected, near 'Id'.
You should use single quotes:
UPDATE TABLE1 SET name='stack' where id=2
精彩评论