Stored Proc

Results 1 to 2 of 2

Thread: Stored Proc

  1. #1
    Join Date
    Dec 1969

    Default Stored Proc

    I am a newbie to ASP and I am simply modifing code to teach myself. The code I have is: (obviously this is not the entire thing)<BR>Set numberRes = SQLQuery("SELECT * FROM client WHERE cid=" & data_id)<BR><BR>I do know a bit about SQL so what would I change in order to make this simple select statement a stored procedure. Lets say the Stored Procedures name is SProc_Example. Is there a simple way to get this to run? Assuming I already have a connection with the DB.<BR><BR>Heather

  2. #2
    Ed Guest

    Default RE: Stored Proc

    Create the sp on your server... Then call it:<BR><BR>conn.Execute(sp)

Posting Permissions

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