In order to enable editing via ODBC, Azure tables cannot have null values in them. When creating tables, I often forget to add defaults. Here’s how to do it after-the-fact.
ALTER TABLE products
ADD
CONSTRAINT [DF_tblmytable_price] DEFAULT ((0)) for price,
CONSTRAINT [DF_tblmytable_productname] DEFAULT (('blank product name')) for productname
run that for each column and you’re all set.
