EXEC sp_executesql @sqlQuery, how to receive its data in variable

Vikram Kumar answered on August 4, 2023 Popularity 1/10 Helpfulness 3/10

answer EXEC sp_executesql @sqlQuery, how to receive its data in variable

EXEC sp_executesql @sqlQuery, how to receive its data in variable

Comment

DECLARE @sqlQuery NVARCHAR(MAX);
DECLARE @tableName NVARCHAR(100) = 'YourTableName';
DECLARE @columnName NVARCHAR(100) = 'YourColumnName';
DECLARE @filterCondition NVARCHAR(100) = 'YourFilterCondition';
DECLARE @result INT; -- Change the data type as per your column's data type

SET @sqlQuery = N'SELECT @result = ' + QUOTENAME(@columnName) + ' FROM ' + QUOTENAME(@tableName) + ' WHERE ' + @filterCondition;

EXEC sp_executesql @sqlQuery, N'@result INT OUTPUT', @result OUTPUT;

-- Now @result variable contains the value from the executed query

Popularity 1/10 Helpfulness 3/10 Language sql

Source: chat.openai.com

Tags: exec sql

Link to this answer
Share Copy Link

Contributed on Aug 04 2023

Vikram Kumar

0 Answers Avg Quality 2/10

EXEC sp_executesql @sqlQuery, how to receive its data in variable

Contents

More Related Answers

EXEC sp_executesql @sqlQuery, how to receive its data in variable

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.