Jump to content

JMerrill

Members
  • Posts

    2
  • Joined

  • Last visited

Posts posted by JMerrill

  1. I am new to the ways of SQL and any other languages.I need to know if these functions (below) work 'on line' or if I'm coding in error.I am enjoying learning SQL but not knowing if it is me or the site is a bit frustrating.Thanks all,JMIn The online “SQL Try It” using the Customers table in the Northwind database:INSERT INTO customers (CustomerID, CompanyName)VALUES ('aasa', 'bobco')Gives this result : Operation must use an updateable query.UPDATE CustomersSET Address = 'Stien 12', City = 'Stavanger'WHERE CustomerID = 'ALFKI'Gives this result : Operation must use an updateable queryDELETE FROM CustomersWHERE CustomerID = 'ALFKI'Gives this result : Could not delete from specified tables.DELETE * FROM CustomersGives this result : Could not delete from specified tables.

×
×
  • Create New...