How to Select execute 'dynamic sql' from stored procedure?

Question

In a stored procedure I'm constructing dynamic SQL which is available in a variable like below:

DECLARE @SqlQry VARCHAR(max) 
SELECT @SqlQry = @SQL  --@SQL has dynamic SQL already.

I can execute this SQL statement like this:

exec (@SqlQry);

My question is how to select and returned results of this execution. I want to return these results just like a normal select statement. Please guide.

mxix · Accepted Answer · 2014-10-12 23:55:52Z

2

If your statement is a select it will return the dataset as a regular select would.

DECLARE @SqlQry NVARCHAR(max) = 'select wtvr from wtvr'


exec sp_executesql @SqlQry

answered Oct 12, 2014 at 23:55

mxix

3,6591 gold badge18 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Select execute 'dynamic sql' from stored procedure?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related