SQL Update - error: invalid column name

0
Hey guys, I am trying to run the following sql statement (database connector) for updating a column value: 'UPDATE [Northwind].[dbo].[Categories] SET [Northwind].[dbo].[Categories].[CategoryName] =  ‘Beveragess’ WHERE [Northwind].[dbo].[Categories].[CategoryID] = 1' Other inputs like the jdbc-url, user name and password are alright. While running the sql-update the error ‘invalid column name ‘beverages’ ’ occurred. How should I handle the new value ‘Beveragess’? Are there any missing quotation marks?   Cheers, Daniel
asked
0 answers