Sprocs v. embedded queries

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

I've read that the advantages of sprocs over embedded queries is that the
former are compiled once.

Does one loose the advantages of stored procedures when one concatentates a
lot of strings together and then uses the EXEC function to execute the
subsequent query? I'm seeing a lot of this in the stored procedures I'm
debugging.

Thanks,
Siegfried
.

Relevant Pages

  • RE: view vs sproc
    ... i contest. ... Sprocs are for wen you need paramaters although ... Users of SQL server often dont ... In many other databases views are a better choice over using stored procedures for ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Using Stored Procedures with a Grid View
    ... my gridview and formview controls in a current project. ... I found that for the delete and update sprocs I had to specify the primary ... > I'm trying to use Stored Procedures with a Grid View and everytime I try ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: view vs sproc
    ... Sprocs are for wen you need paramaters although ... Users of SQL server often dont ... In many other databases views are a better choice over using stored procedures for ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to: Can you build a Typed DataSet for a stored procedure w/o using a DataAdapter?
    ... > If you want to create a DataSet, you can drag tables from Server explorer ... > into it, but not stored procedures. ... > sprocs instead of tables? ... and it creates the typed dataset with the results the stored procedure ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: parallelism
    ... the Query Optimizer to decide; there is no change you can to your sprocs to ... > We are running our SQL Server on a computer with eight CPUs. ... > We would like some of our larger stored procedures to be run in parallel ...
    (microsoft.public.sqlserver.programming)