I just finished looking into this! 🙂

You can use "SQLCMD Mode" in SSMS. To enable it go to the Query menu and select "SQLCMD Mode"

:connect <ServerName>\<InstanceName>

use [Database]

go

SELECT *...