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).
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.
Look into this: