Articles & Content
DATE: 2006-5-9 (08:30 AM - 09:40 AM)
SPEAKERS: June Hunt (Tyler Technologies Inc., MUNIS Division)
There are a few questions that come up time and time again. Why do certain SQL statements behave the way they do, and how do I get a particular set of results? This presentation will cover some of the most frequently asked SQL-related questions. We'll also discuss how to find out how others have found answers and solutions to similar problems.
EXP. LEVEL: Beginner,Intermediate
DATE and DATETIME calculations and comparisons
Using CURRENT in stored procedures
COUNT, ORDER BY, and other special conditions
Explain plan query estimates
Replace newlines in text
Click Here to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.