Separation of DDL and DML - was: Early and late binding.



x wrote:
With a SQL DBMSs one is forced to separate DDL from DML which may or may not
be a good thing.

OK - I'm going to bite. In what respects does SQL enforce DDL separate from DML? And if you didn't do it the SQL way, how would you do it?


I suspect I know parts of the answer to the first question - but I do not understand why you think it a bad thing. I have no ideas about the second question yet.

--
Jonathan Leffler                   #include <disclaimer.h>
Email: jleffler@xxxxxxxxxxxxx, jleffler@xxxxxxxxxx
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/
.



Relevant Pages

  • Re: Help with Names
    ... First question is the toughie. ... How regular is your data. ... SQL Server MVP ... > The source is an excel spreadsheet that I've imported in to SQL 2000. ...
    (microsoft.public.sqlserver.programming)
  • RE: Transferring tables between SQL2005 databases causes error
    ... you import data from one SQL 2005 database to another; ... For your first question, ... Had the destination database tables created with constraints before ... its size were equal to the destination table column type and the size. ...
    (microsoft.public.sqlserver.dts)
  • Re: Display Database Query in Visio
    ... I guess the first question is, what are your sql skills since it is ... I have a network diagram with a number of system (server) components ... What I want is a way of performing a SQL query based on a value of one ...
    (microsoft.public.visio.developer)
  • Re: RAM chips & Airport Extreme card
    ... Jon B wrote: ... >> First question: ... Officially, they'll only work in G4s, Apple state that they're DDR333, ...
    (uk.comp.sys.mac)
  • Re: SQL Server Clustering - OS(64-Bit) SQL (32-Bit)
    ... This applies on a cluster as well as a stand-alone ... system, so the answer to your first question is yes, it can be set up that ... You cannot do an in-place upgrade because of the 32 to 64 bit ... but you can install a second SQL instance using SQL 2005 on the ...
    (microsoft.public.sqlserver.clustering)