Results 1 to 2 of 2

Thread: difference

  1. #1
    Join Date
    Aug 2003
    Posts
    3

    Angry difference

    hello!
    sorry, i don´t speak english.
    hello again!
    It what differs it is between these two sentence?
    - exec (' exec sp_MShelpindexPru cliente,'+''+@indexid+''+'output')
    -exec sp_MShelpindexPru cliente,@indexid output

    Supposedly, they are equal , no?
    None gives me mistake, but The first one does not give me a result And the second one gives me the correct result. Which is the difference between both?
    I need to do it of the second form, because I need to insert one it use @dbname initially.
    Thank you very much, and excuses me for my English.";

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Did you try
    exec ('exec sp_MShelpindexPru cliente, @indexid output')

    By the way, why do it this way at first place?

Posting Permissions

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