Re: ASP - Stored Procedure best practice?

Sorry Erland. Didn't notice it was from someone else. Much thanks to you
also.

Take care.

J

"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns98BDEE90C4CB3Yazorman@xxxxxxxxxxxx
J (IDontLikeSpam@xxxxxxxxxxx) writes:
Do you know of a recommended method in doing this for a form with
multiple
fields which allows a user to specify more criteria on multiple fields?
Seems like building the dynamic sql statement in the stored procedure
with
the specified field parameters is the only method I can think of to do
multiple criteria searching but I guess I still would like to avoid.

I discuss a whole bunch of solutions in both dynamic and static SQL, as
well as some very interesting hybrids in an article on my web site:
http://www.sommarskog.se/dyn-search.html.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx


.

Relevant Pages

  • Re: ASP - Stored Procedure best practice?
    ... fields which allows a user to specify more criteria on multiple fields? ... multiple criteria searching but I guess I still would like to avoid. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: ASP - Stored Procedure best practice?
    ... fields which allows a user to specify more criteria on multiple fields? ... multiple criteria searching but I guess I still would like to avoid. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: ASP - Stored Procedure best practice?
    ... Do you know of a recommended method in doing this for a form with multiple ... fields which allows a user to specify more criteria on multiple fields? ... multiple criteria searching but I guess I still would like to avoid. ... dynamic sql in the stored procedure but hear that it's not good practice ...
    (microsoft.public.sqlserver.security)
  • Re: Veritas storage foundation HA for windows
    ... This is a solution to manage your data, not the services like SQL Server. ... To make an application cluster suitable ("cluster aware" is for used for ... Most of the time that we have hardware failure, ... Hope you have multiple generators, multiple UPS's, multiple switches, ...
    (microsoft.public.sqlserver.clustering)
  • RE: time criteria in query
    ... "Harry F." ... I don't have access to the actual SQL server ... in which case you'd surround your date criteria with single-quotes ... Which date/time type are you using in Sql Server? ...
    (microsoft.public.access.queries)