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. :-(Look into using sp_execute_sql instead. See if this helps:
http://support.microsoft.com/default.aspx?scid=kb;en-us;262499
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
<mani14@.begira.com> wrote in message
news:ca48b635.0308190221.9b9a596@.posting.google.com...
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. :-(|||Hello Mani !
But remeber that for SP_executesql the @.string followed to be executed must
be NVARCHAR !
Jens Süßmeyer.