Results 1 to 2 of 2

Thread: Query..

  1. #1
    Join Date
    Dec 1969

    Default Query..

    i have a query "select * from tablename"<BR>i used to write this qurey in ASP page get all recordset. You please tell me is it worth writing the same query in Stored procedure. How it effects for the efficiency. Is it worth writing a single query in stored procedure.

  2. #2
    Join Date
    Dec 1969

    Default RE: Query..

    to be honest, i have not noticed the difference between a query if it is in a stored procedure or straight from the page, the biggest difference is in organization and readibility of the code. Some really complicated queries look real nasty in asp<BR><BR>sponge

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts