SQL to show output results

I have prepared a sql file mysql.sql

Satement1
Go
Statement2
Go

When I run in SSMS, I want to see each batch followed by its
results:
Statement 1
Go
Results from above batch 1
Statement2
Go
Results from above batch 2


Is there a way to get this output? In Oracle one can use "SET ECHO ON"/"SET FEEDBACK ON"

Is there anything equivalent in SQL server?

Thanks,

~sve
LVL 18
sventhanAsked:
Who is Participating?
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
simply wrap up the two statement in one then SQL  will return the outputs in one run.
0
 
sventhanAuthor Commented:
I've to capture this in SQLCMD. So we could verify our deployment.
0
 
sventhanAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.