ASP - Stored Procedure best practice?

Hello. I was wondering if anyone would recommend or point me to a best
practice method in programming a search field on an .asp page that calls a
SQL Server stored procedure to do 'LIKE' searches? The only method that
seems to accommodate this that comes to my mind as of now is using dynamic
sql in the stored procedure but hear that it's not good practice using
dynamic sql.

Thanks in advance.

J


.

Relevant Pages

  • Re: Store procedure vs Direct statement ???
    ... advantage over dynamic sql because of executing on the server, ... sql also executes on the server. ... In response to your example of stored procedures having a security advantage ... Let's say you have a stored procedure called InsertCustomer, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SP - output parameter not coming back
    ... I just looked at your stored procedure. ... >> You're using dynamic sql in your stored procedure?!? ... Erland is a well-respected SQL Server MVP so you can be sure his ideas have ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Sql server 2000 paging
    ... If you want to do true paging on the database end then you will aso need ... know of is using dynamic SQL. ... proc then dynamic SQL is also the only way. ... I am thinking of using dynamic sql, so I would have a stored procedure ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Alternative to Dynamic SQL?
    ... If security is that much of a concern, shutdown your sql ... each database is suppose to have an application ... search querying using stored procedure and found it invalid. ... dynamic SQL, modern database engines actually cache dynamic sql and ...
    (microsoft.public.sqlserver.programming)
  • Re: Dynamic SQL instead of stored procs?
    ... How are you calling the stored procedure and the dynamic sql from the ... When did writing the SQL in code become just as good as using procs? ...
    (microsoft.public.dotnet.languages.csharp)