Command to Display at Bottom Of Query Window.

[grnzbra]

This is the lower left corner of a T-SQL querywindow. What I would like to do is add code that, as a loop runs, displays the remaining records to be processed. I know how to get the number buy don't know how to put it where the "Ready" label is. I've done it in Access. Is there a way to do it in SQL Server?

 

[Olaf Doschke]

I don't think you can. SQL Management Studio isn't a frontend tool like Access is. Besides that, when you'd use Access as a frontend and execute queries I doubt you'd get progress info. You get the result with unknown result size unless you first do a query giving you the count and/or use cursors and a fetch loop. You may then look into PRINT and/or RAISEERROR, but you can't put that into a query.

PRINT:

https://docs.microsoft.com/en-US/sql/t-sql/language-elements/print-transact-sql?view=sql-server-2017

RAISEERROR:

https://docs.microsoft.com/en-US/sq...s/raiserror-transact-sql?view=sql-server-2017

Bye, Olaf.



Olaf Doschke Software Engineering

https://www.doschke.name

 

[grnzbra]

Thanks. I was afraid that was the situation.