SQL Server Results Set

Question

In the below screenshot, is there any means to "label" a SQL command so that if a service of commands are ran, you know what each result is for (using SQL Server Management Studio):

I.e.,
(1 row affected) could be something like "Insert STP Entry: (1 row affected)"

We have some scripts that are long, but get reran a lot and would like to be able to easily determine what each result represents.

Thanks,
Bill

Answer 1

You can use RAISERROR to return messages - and use SET NOCOUNT ON at the beginning to turn off the default:

Set Nocount On;  
Declare @stepName varchar(30) = '';  
  
<some other code here>  
  
Set @stepName = 'Insert STP Entry';  
  
<Insert STP Entry code here>  
  
Raiserror('%-*s: %i', -1, -1, 30, @stepName, @@rowcount) With nowait;  

Results will be displayed as:

Insert STP Entry : 1 rows affected

Lookup RAISERROR for additional ways you can format the results.

Answer 2

Both of the above answers work. The first one with the print statements works but the output is a little confusing by the new line space:
Insert into STP History Table

(1 row affected)
Insert into File History Table

(1 row affected)
Delete from STP Table

(1 row affected)
Delete from FileTable

(1 row affected)

The second method above was a lot cleaner but takes a little more work:

Insert STP Batch into History Table : 0
Insert Files into History Table : 0
Delete Files : 0
Delete STP : 0