Browse by Tags
All Tags »
Cole Joke (
RSS)
In ANSI 92 there are two styles of writing SQL, there is what is commonly referred to as the old or ANSI 89 style, that is the style where you put the join criteria in the WHERE clause; the other style is referred to either ANSI 92 or the new style and...
Hopefully this will put to bed the lobby that recommends you use COALESCE for queries that have optional specified parameters, the real world example would be a search form where the user can optionally choose from a number of drop down lists and then...
Introduction Application programmers and Business Intelligent professionals are faced with having to format data - taylored into what the users want. We have two choices as to where we do this processing, keep it in the database using the facilities of...
Introduction This is a common problem within database design and implementation and often discussed with great passion within the community. Most tables, allthough not all have a natural key, with some however its just not practical to use the natural...