In Oracle, you can "Set echo on" and when you run a script the query and the output are output in the results. I want to do the same in SQL Server. I am unit testing in SQL Server and I want to see both the query and the results in the log file I attach to my unit test document.
Can someone help me? I am using Microsoft SQL Server Management Studio for 2005.