Re: Help constructing View

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Joe Celko (joe.celko_at_northface.edu)
Date: 03/23/04 

Date: Tue, 23 Mar 2004 08:03:13 -0800

>> know of a good reference material targeted at people in between the
elementary and genious level. I find most material is either aimed at
the base of the ladder, or the top of the ladder. <<

{{ begin shameless plug}}
I like SQL FOR SMARTIES for people heading for the top end, but I also
did a SQL PUZZLES & ANSWERS book that explains several different
solutions to a given SQL problem. The my next one is on various models
for trees & hierarchies in SQL.
 
{{ end shameless plug}}

--CELKO--
 ===========================
 Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in your
schema are.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: D7 errors with complex dataset command text
    ... I did try changing this to a view but SQL won't let me update it if ... You can have updatable views by using Instead Of triggers (see Books Online) ... or use TClientDataSets ...
    (borland.public.delphi.database.ado)
  • Re: Help constructing View
    ... Besides Joe Celko's books, I would also advice reading SQL Server Magazine ... >> {{begin shameless plug}} ...
    (microsoft.public.sqlserver.programming)
  • Re: Help constructing View
    ... I bought and use your Advanced SQL Programming... ... I have moments of clarity when I completely understand what is happening, ... > {{begin shameless plug}} ...
    (microsoft.public.sqlserver.programming)