does SQL Server take advantage of 'bind variables'

[Ryan]

Using prepared statements like Oracle does? This way in a high transaction
system you do not have to recompile queries every time?

[Joe Weinstein]

Ryan wrote:

Using prepared statements like Oracle does? This way in a high transaction
system you do not have to recompile queries every time?

Yes it does have this capability.
Joe Weinstein at BEA

[Simon Hayes]

"Ryan" <rg******@cox.net> wrote in message news:<ZVlPb.5755$_H5.281@lakeread06>...

Using prepared statements like Oracle does? This way in a high transaction
system you do not have to recompile queries every time?

In general, query plans are cached (unless they're very simple), but
may be aged out of the cache if they're not used. Stored procedures
are generally the most efficient way to code, although they may be
recompiled in some situations. Profiler can show cache hits, misses
and recompilations for stored procs.

Simon

[hrishy]

Hi Ryan

Yes every database i know of including sql server will make use of
bind varaiables..bind varaiables are not the exclusive doamin of
oracle.

regards
Hrishy
"Ryan" <rg******@cox.net> wrote in message news:<ZVlPb.5755$_H5.281@lakeread06>...

Using prepared statements like Oracle does? This way in a high transaction
system you do not have to recompile queries every time?