Solved

SQL to show output results

Posted on 2011-02-19
3
433 Views
Last Modified: 2012-05-11
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
Comment
Question by:sventhan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 18

Author Comment

by:sventhan
ID: 34934289
I've to capture this in SQLCMD. So we could verify our deployment.
0
 
LVL 23

Accepted Solution

by:
Racim BOUDJAKDJI earned 500 total points
ID: 34934412
simply wrap up the two statement in one then SQL  will return the outputs in one run.
0
 
LVL 18

Author Closing Comment

by:sventhan
ID: 34956209
Thanks.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question