SQL Server Stored Procedure and ASP

Results 1 to 2 of 2

Thread: SQL Server Stored Procedure and ASP

  1. #1
    Join Date
    Dec 1969

    Default SQL Server Stored Procedure and ASP

    &nbsp;<BR>Hi,<BR><BR>Please can you assist me I am creating a registration page with asp which the allow the user to insert Personal details, Delivery address and credit card details. The details all go into 3 different tables. I want to be able to use 1 strored procedure to carry out the insert into the individual tables however because there are over 40 fields it means that the number of parameters being into the stored procedure is quite bulky - can anyone suggest a neater and less bulkier way of inserting all the details into the tables using SQL Server 2000. <BR><BR>Thanks <BR>

  2. #2
    Join Date
    Dec 1969

    Default Use COM

    and pass the parmaters in as an array... you&#039;ll have to seperate &#039;em out in the object, but hey... the only other solution is to not use 40 different things at once.

Posting Permissions

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