Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    7

    Unanswered: Dynamic SQL with output values

    Hi:

    How can I in SQL Server 2000 (using Transact SQL) execute a dynamic sql string and at the same time retrieve output params ?

    Thanks

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Please give a specific example. What are the output parameters ? Are they based on the dynamic sql ? Where are you retrieving the output parameters from ?

  3. #3
    Join Date
    Sep 2002
    Posts
    7
    Originally posted by rnealejr
    Please give a specific example. What are the output parameters ? Are they based on the dynamic sql ? Where are you retrieving the output parameters from ?
    Here's an simple example:

    SELECT @num_records = COUNT(*)
    FROM @TableName

Posting Permissions

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