Syntax to PRINT the row counts using Dynamic SQL?

Question

Hello, what would be the syntax to PRINT the row counts using Dynamic SQL (in my case here need to get the row counts via a Linked Server View)

I would like to have this as a step in a SQL Agent job which after it runs it PRINTs the row counts in it's job step in case need to review afterwards.

Thanks in advance.

Answer 1

Hi @techresearch7777777

How about this:

DECLARE @SQL_STRING NVARCHAR(MAX), @rows INT
SET @SQL_STRING = 'Your SQL Code Here'
EXEC sp_executesql @SQL_STRING
SELECT @rows = @@ROWCOUNT
PRINT '@rows = ' + CAST(@rows AS VARCHAR(10))

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

PRINT concat('Rowcount is ', @@rowcount, '.')

Not sure why you would use dynamic SQL.

Then again, I'm not sure what you are trying to do overall. Your post could benefit from some clarification.