开发者

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
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜