Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dynamic Query Problem
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01518212
Message ID:
01518244
Views:
50
>Yes you didn't declare it :-)
>The Dynamic SQL is executed in separate batch and any local variable declared in current batch is not visible there.
>You must use sp_executesql:
>
>DECLARE @voter_id INT
>SET @Command = 'SELECT @voter_id = voterid FROM tblCamp_CT WHERE VoterId = ' + CAST(@VoterId AS VARCHAR(20)) + ' AND ' + @Query
>
>EXEC sp_executesql @Command, N'@voter_id int OUTPUT', @voter_id = @voter_id OUTPUT
>
Ok, I tried this
DECLARE @voter_id INT
SET @Command = 'SELECT @voter_id = voterid FROM tblCamp_CT WHERE VoterId = ' + CAST(@VoterId AS VARCHAR(20)) + ' AND ' + @Query
EXEC sp_executesql @Command, N'@voter_id int OUTPUT', @voter_id = @voter_id OUTPUT
SELECT @voter_id
and I'm now getting
Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.
Not sure what @statement' is.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform