Stored procedures

Results 1 to 2 of 2

Thread: Stored procedures

  1. #1
    Join Date
    Dec 1969

    Default Stored procedures

    Does anyone know of a good resource for something like "Best practices for writing stored procedures"?<BR>I am new to using stored procedures in my ASP code, and most of the help out there is just on how to call stored procedures...not how to best write them.<BR>Though I do have a question about that. What is the most efficient way to call a stored procedure?<BR><BR>1) objCmd.Parameters.Append objCmd.CreateParameter<BR>Set objRS = objCmd.Execute<BR><BR>OR<BR><BR>2) set objRS = objConn.Execute("EXECUTE sp_mysp")<BR><BR>Do I even need the EXECUTE statement? Would that affect performance?<BR><BR>Thanks.

  2. #2
    Join Date
    Dec 1969

    Default Download the code example... this article. It shows many ways to do this as part of<BR>the articles test.<BR><BR>

Posting Permissions

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