Re: Need help with Tricky SELECT statements please.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Joe Celko (jcelko212_at_earthlink.net)
Date: 04/25/04 

Date: Sun, 25 Apr 2004 09:43:12 -0700

>> I was also taught early that it was best to do as much manipulation
using SQL as possible. <<

Look at how many people here are writing application code in T-SQL --
converting everything to strings and trying to pass one, long
concatenated string as output. Did you ever write in COBOL? Same
thing.

>> .. seminar I attended with Dr. David Rozenshtein, .. his book The
Essense of SQL <<

Dave and I used to do the DCI shows years ago! Is he still teaching? I
still wish I was as good presenter as he was -- his Russiam accent was
actually an advantage.

>> The real question is can we build a properly tiered architecture
that includes a data manipulation tier that has the power of a
relational language, rather than a procedural one? <<

and a separate business rules layers that is also declarative?

--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: Need help with Tricky SELECT statements please.
    ... Pro SQL Server 2000 Database Design ... > concatenated string as output. ... >>> The real question is can we build a properly tiered architecture> that includes a data manipulation tier that has the power of a> relational language, ... > Please post DDL, so that people do not have to guess what the keys,> constraints, Declarative Referential Integrity, datatypes, etc. in your> schema are. ...
    (microsoft.public.sqlserver.programming)
  • Re: Help: Stored Procedure performance issue.
    ... Please post DDL, so that people do not have to guess what the keys, ... We do not use flags in SQL. ... are no more than n days apart) and other constraints are met (the cargo ...
    (comp.databases.ms-sqlserver)
  • Re: Identity field question
    ... referenced it in other tables and basically built an IDMS style pointer ... I have done two conversions from "IDMS in SQL" to a relational design. ... constraints, Declarative Referential Integrity, datatypes, etc. in your ...
    (microsoft.public.sqlserver.programming)
  • Re: Generating SQL
    ... Concatenated string are a PITA. ... most CRUD I encounter is not that simple. ... > SQL. ... There is no substitute for good database design. ...
    (comp.object)
  • [ECHO_ADV_102$2009] BusinessSpace <= 1.2 (id) Remote SQL Injection Vulnerability
    ... Manipulation of data / Exposure of sensitive information ... in sql queries.This vulnerability can be exploited to manipulate SQL queries by injecting arbitrary SQL code. ... Successful exploitation allows attacker retrieving users email and password in plain text. ...
    (Bugtraq)