Wednesday 15 May 2013

stored procedures - SQL Best Practices -


Is it good to check that some fields are empty from a table and will return true or false from SP or what values It is good to bring and check in code.

This is usually a better design for a specific business layer, which validates the field for example In a n-tier architecture, the business level will be valid and if the required field disappears then an error will be returned. This means that the data level expects the valid data coming from the business level.

All data levels need to be worried about the recovery of data efficiently and efficiently.


No comments:

Post a Comment