[dba-SQLServer] Difference between views and queries

Francisco,

Francis Harvey wrote On 6/25/2004 2:24 PM:

>Do some research on the basic solutions for SQL that has to adjust for
>varying databases, conditions (dynamic search), or servers (different
>SQL dialects). Some designs also call for encapsulating business logic
>outside of the data tier. In these situations, dynamic SQL is often
>the only logical choice. I have only had to deal with dynamic search
>myself, but this is enough to convince me of its usefulness.

Basically, some of them aren't really up for debate. If you need your
business logic outside of your data tier for business or performance
reasons, then it isn't a programming choice anymore. Similarly, I
would think with needing to speak more than one SQL language in terms
of maintenance or design considerations.

Francis R Harvey III
WB 303, (301)294-3952
harveyf1 at westat.com