DataGrip showing prints during a transaction

Question

I have a long running update query, for this reason I used the old well known trick of dividing the query in smaller chunks of 1000 to be print the status of the query and calm the anxiety.

Unfortunately DataGrip seems to write to output all the print at the end of the query, witch makes it useless. Is it possible to print the updates the same way as Visual Studio?

Answer 1

The PRINT statement as you have experienced will not display right away. When you would like to see progress, you can use RAISERROR with NOWAIT for that.v

DECLARE @Msg NVARCHAR(200) = CONCAT('Processing chunk ', @currChunk, ' of ', @numChunks);
RAISERROR(@Msg, 10, 1) WITH NOWAIT;

Shows my result from my testscript:

DECLARE @currChunk INT = 1;
DECLARE @numChunks INT = 20;

WHILE @currChunk < @numChunks
BEGIN

    DECLARE @Msg NVARCHAR(200) = CONCAT('Processing chunk ', @currChunk, ' of ', @numChunks);
    RAISERROR(@Msg, 10, 1) WITH NOWAIT;

    SET @currChunk = @currChunk + 1;

    WAITFOR  DELAY '00:00:02'   /*delay for simulating progress*/

END;

See also: https://www.sqlshack.com/sql-server-print-and-sql-server-raiserror-statements/

Answer 2

In DataGrip 2023.1 suggested code:

DECLARE @currChunk INT = 1;
DECLARE @numChunks INT = 20;

WHILE @currChunk < @numChunks
BEGIN

    DECLARE @Msg NVARCHAR(200) = CONCAT('Processing chunk ', @currChunk, ' of ', @numChunks);
    RAISERROR(@Msg, 10, 1) WITH NOWAIT;

    SET @currChunk = @currChunk + 1;

    WAITFOR  DELAY '00:00:02'   /*delay for simulating progress*/

END;

shows a valid output in console output.