• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 438
  • Last Modified:

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
0
sventhan
Asked:
sventhan
  • 2
1 Solution
 
sventhanAuthor Commented:
I've to capture this in SQLCMD. So we could verify our deployment.
0
 
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:
Thanks.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now