Carlo Romagnano (4/18/2014)
When results come out in text, you can search for a string (ctrl+f), instead, in grid mode you can not search in the results.
You can copy paste the grid easily to Excel though.
And with Text mode it's not easy to see how many rows were returned.
Another advantage of text is that is usually returns results much faster than the grid.
And it's better to test dynamic SQL 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP