Error in Update statement - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Error in Update statement

Author

Topic

rink
Starting Member

1 Post

Posted - 2012-03-31 : 16:44:30

Update BookInfo
Set Category = Enginnering , Publisher = Medical Eng Pubs ,
Book = Medical Enginnering Part X , Author = Steve Jobs ,
Price = 6500.0000 , [Total Quantity] = 8000.0000
Where ISBN = '80071666610962 '

Error is - Incorrect syntax near 'Eng'.

what's wrong i don't understand..please let me know. Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-03-31 : 18:17:48

Update BookInfo
Set Category = 'Engineering', Publisher = 'Medical Eng Pubs' ,
Book = 'Medical Enginnering Part X' , Author = 'Steve Jobs' ,
Price = 6500.0000 , [Total Quantity] = 8000.0000
Where ISBN = '80071666610962 '

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-03-31 : 19:27:03

look into BOL and learn syntax of UPDATE statement

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources