Re: Conditionally Adding SQL

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

Linchi,

I just went through and read a few of Joe's posts, so perhaps you are correct in his outlook.

SQL = (DDL, DML)

Everything else is not SQL, just proprietary stuff that should be done in some other language anyway. (Aside from the fact that the DDL and DML may not always measure up to the pure language of SQL.)

RLF

"Linchi Shea" <LinchiShea@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:C713C5EC-06AA-4849-AA41-F2C53901A1B9@xxxxxxxxxxxxxxxx
Original post aside, I have to agree with Joe here. After all, he said SQL,
not T-SQL. As to how far you cna get in real world solving real problem with
just SQL and without any control flow is quite another matter.

Linchi

"Aaron Bertrand [SQL Server MVP]" wrote:

> There is no need for local variales and flags in SQL.

What an absurd declaration!



.

Relevant Pages

  • Re: Separation of DDL and DML - was: Early and late binding.
    ... >> With a SQL DBMSs one is forced to separate DDL from DML which may or may ... In what respects does SQL enforce DDL separate ... > from DML? ...
    (comp.databases.theory)
  • Re: limits of SQL Server???
    ... choosing "Generate SQL Script" (depending on where you are you may first ... actual value to see how well the query performs just by itself. ... to see the DDL including the indexes for these tables and a count of how ... >> selecting 400 rows is nothing for sql server. ...
    (microsoft.public.sqlserver.setup)
  • Re: Inserting multiple records into two tables...with a twist
    ... Mind showing us their DDL? ... violation of basic RDBMS design -- redundancy is to be avoided via ... writing SQL at all. ... newsgroups are places to get kludges and not an ...
    (comp.databases.ms-sqlserver)
  • Re: Dynamic VB Code Behind
    ... 'Dynamic Master/Detail Controls', but as I started abstracting the ... In this case when the user selects which report they want to run from a ddl ... My code will read from sql that it needs to create a ddl ... 'save' the SelectedIndexChanged event code in sql and send it to an Execute ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Early and late binding.
    ... > With a SQL DBMSs one is forced to separate DDL from DML which may or may ... To relate your last point back to binding, ... where the model is static between DDL transactions. ... not coded as DML, but as something else. ...
    (comp.databases.theory)