software master at the intersection of technology, science and art


sql standards

Stored procedures require severe discipline in structure and exception handling. In my opinion, stored procedures are an essential part of a data driven system. The stored procedures limit access to a control pathways to the data and, as they are pre compiled, perform well.