Home > Articles > Data

  • Print
  • + Share This

Some Unsupported SQL

As we said earlier, WSS SQL can be used only to query data, not to update. Although the discussion we've presented here is not an exhaustive treatment of the language, by now you should have a very good idea of what you can and cannot do with it. With this in mind, note that the following SQL statements are simply not supported in WSS SQL:

  • AVG

  • CONVERT (WSS SQL uses CAST instead)

  • COUNT

  • CREATE VIEW

  • DELETE

  • DROP INDEX

  • INSERT

  • JOINS (all kinds)

  • MAX

  • MIN

  • SELECT DISTINCT

  • SET

  • SUM

  • UPDATE

  • + Share This
  • 🔖 Save To Your Account

Related Resources

There are currently no related titles. Please check back later.