Articles & Content

Archives

Common SQL Questions: Why and How-to (L04)

Topic: 2006 NA

Subtopic: Informix



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

OBJECTIVES:

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



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.