Results 1 to 2 of 2

Thread: SQL Server

  1. Aug 7th, 2000, 04:49 PM #1
    WadeD
    WadeD is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 1999
    Posts
    363
    Hi, in my app, I'm using stored procedures in SQL Server. Is it possible to have 1 stored procedure return results from another? I want to pass an employee name to the main sp, have the main sp call another sp (that parses the name and returns the result), and then have the main sp update the employee's record.

    Thanks.
    Wade
    Reply With Quote Reply With Quote
  2. Aug 7th, 2000, 04:59 PM #2
    JHausmann
    JHausmann is offline
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    Set your database to "master" (in Enterprise Manager) and take a look at some of the system stored procedures, sp_help and sp_addgroup being some good examples of what you want to do...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width