Sometimes when you make a SQL script, that loops through a lot of records, you want to print a status. When you do this using print (or select), this will only display the content when the buffer is full. To immidiatly print everything to the screen use:
|
1 |
RAISERROR ('here', 0, 1) WITH NOWAIT |
This will flush the buffers to screen and so you will see the output immediately.