Using a stored procedure is the best way to interact with a database. I’ll use an example from the Dilithium Networks TCAN system (case.aspx).
Adding Default Values to Azure tables
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.
DHTMLX Drag and Drop.
Look into this: