Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    38

    Unanswered: Testing a stored procedure?

    Is there a way to test a stored procedure in SQL Server?

    TIA

  2. #2
    Join Date
    Mar 2003
    Posts
    130
    Use the Query Analyzer packaged with SQL server.
    In the Query window type:

    use [DatabaseName]
    exec [StoredProcedureName]

    and click the Execute Query (->) button.
    Last edited by wey97; 02-26-04 at 13:34.

Posting Permissions

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