Home > Articles > Data

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

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.