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