Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    29

    Unanswered: Declare variables in procedure

    I have 2 stored procedures that use the same names for variables, can I create a third stored procedure that only has the declare statements in order to save code?
    ----------------

    PROC 1
    declare @date
    declare @time
    -------------------
    PROC 2
    declare @date
    declare @time
    ----------------------

    Can I have something like:

    PROC 1
    exec get_variables
    PROC 2
    exec get_variables

    PROC get_variables
    declare @date
    declare @time

  2. #2
    Join Date
    Feb 2004
    Location
    Norway
    Posts
    7
    The thread "Include files" might give you some alternatives: http://www.dbforums.com/t984730.html

Posting Permissions

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