Groups > comp.databases.ms-sqlserver > #1307

explain? Execution plans?

Newsgroups	comp.databases.ms-sqlserver
Date	2012-09-20 02:05 -0700
Message-ID	<c42ab89c-f4c1-4d85-aa89-c061471436a0@googlegroups.com> (permalink)
Subject	explain? Execution plans?
From	björn lundin <b.f.lundin@gmail.com>

Show all headers | View raw

In others databases, I can run
explain (some query)
and get a execution plan.

We have a tool that parses source code for
sql statements and runs explain on them.
By doing this, we get
* the execution plan (obviously)
* but also a receipt that the embedded sqls are valid.

Sometimes an sql is written differently in Oracle compared to sql-server.
one example is substr/substring but there are others.

Yes, I could define a function that is called substr, and implement substring
in sql-server, or the other way around, but I prefer to have different
statements then, (case Oracle => , case Sql_Server => case Postgresql => ...)

So, I'm looking for a cli tool that I could feed with a 
sql string that it runs at least a validation check on

Suggestions?


--
Björn Lundin

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

explain? Execution plans? björn lundin <b.f.lundin@gmail.com> - 2012-09-20 02:05 -0700
  Re: explain? Execution plans? Erland Sommarskog <esquel@sommarskog.se> - 2012-09-20 23:36 +0200
    Re: explain? Execution plans? björn lundin <b.f.lundin@gmail.com> - 2012-09-21 01:12 -0700

csiph-web