Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Washington DC area

    Angry Unanswered: stored procedures

    I have a table with:
    Id num
    form varchar
    form_type varchar
    I need to create a sp that returns all date, updates data and pulls data by ID Num.

  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    "by ID" should mean that you need at least one IN parameter which would represent ID.

    "returns all date" (date? data?) - if it's a 'date', no idea. If it is 'data', you'll need another two parameters (OUT this time) which will be used to return fetched values.

    "update data" - write an UPDATE statement which will have ID included into a WHERE clause.

Posting Permissions

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