DECLARE @Value NVARCHAR(50), @Query NVARCHAR(255), @Params NVARCHAR(50)
SET @Query = 'SELECT @Value = 54;'
EXEC sp_executesql @Query, N'@Value int OUTPUT', @Value = @Value OUTPUT
SELECT @Value
You can also feed input parameters if need be...
ASP.Net, SQL Server resource and tips library for the growing
team of peer developers.
DECLARE @Value NVARCHAR(50), @Query NVARCHAR(255), @Params NVARCHAR(50)
SET @Query = 'SELECT @Value = 54;'
EXEC sp_executesql @Query, N'@Value int OUTPUT', @Value = @Value OUTPUT
SELECT @Value
0 comments:
Post a Comment