I Do Declare written by Joe Celko. "Joe Celko highlights some key areas that SQL developers need to be aware of in order to more effectively write SQL code, and offers heuristics for guidance."
You will have to give Idera your info to register. https://www.idera.com/resourcecentral/whitepapers/i-do-declare-sql-programming-language this tip was good. Add a CHECK() constraint for the actual range of the attribute. One of my favorite horror stories was an order entry system that allowed negative quantities. The application treated the negative quantity as a return or refund and sent a check. Order -5000 items at $50 each and wait for the check in the mail! The most common constraints that should be used, but are usually skipped, are to establish cardinals: -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmyko8wercz9jwsq2kaihrkc9ho4eo+c27k2yj62rjla...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
