Re: Performance on parameterized queries vs. stored procedures

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Steve Kass (skass_at_drew.edu)
Date: 03/19/04 

Date: Fri, 19 Mar 2004 10:24:15 -0500

Klaus,

  Parameterized queries are not supported in SQL Server. If you are using a
tool or other application that supports parameterized queries against SQL
Server, then maybe you can look at that applications documentation to see
how such queries are sent to SQL Server, or turn on SQL Profiler when you
issue one and see what is received.

SK

"Klaus Jensen" <CurseThemNastySpammers!> wrote in message
news:%239YLNFcDEHA.2628@TK2MSFTNGP11.phx.gbl...
> "Anith Sen" <anith@bizdatasolutions.com> wrote in message
> news:eiTz67bDEHA.3568@tk2msftngp13.phx.gbl...
> > In certain cases, SQL Server may use shared cacheing of plans & auto
> > parameterization for ad hoc queries which makes it perform comparable to
> > stored procedures. Details can be found under the topic
> > auto-parameterization in SQL Server Books Online.
>
> Thank you for your answer. :)
>
> I am not so much interested in ad-hoc queries vs. stored procedures. It is
> more parameterized queris vs. stored procedures.
>
> - Klaus
>
>

Relevant Pages

  • Re: Access migration to SQL Server
    ... about having to convert all your queries to views and stored procedures. ... so SQL Server won't have to keep recompiling each query ...
    (microsoft.public.access.conversion)
  • Re: Access migration to SQL Server
    ... about having to convert all your queries to views and stored procedures. ... so SQL Server won't have to keep recompiling each query ...
    (microsoft.public.sqlserver.server)
  • RE: SSMA - Query Conversion to Stored Procedures.
    ... you also want to migrate those queries with parameters into SQL Server ... However you found that none of your Access parameter queries are converted ... to stored procedures and that an undefined error came out. ... from the conversion objects list we can see that Access queries can ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Performance on parameterized queries vs. stored procedures
    ... > parameterization for ad hoc queries which makes it perform comparable to ... > auto-parameterization in SQL Server Books Online. ... I am not so much interested in ad-hoc queries vs. stored procedures. ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Tables
    ... No. Queries do not "become" stored procedures. ... In SQL Server, a query is called a "view". ... Stored procedures are collections of SQL statements, ... import the tables back into my front end database, then upsize to the MDB ...
    (microsoft.public.access.adp.sqlserver)