Execute Selective Querys Sql Server

See more:

SQL-Server

When working in a query window in SSMS, primarily a "working development" window with several statements strewn about in various stages of testing/experimentation, it can be a pain (minor, but a pain nonetheless) to have to highlight the desired SQL before hitting F5.

I propose (here we go) 2 SQL execution shortcuts:

1) Execute from the cursor up and down all "connected" text. "Connected" meaning no all-white-space lines separating.
2) Execute ONLY the entire line the cursor is on.

For example, suppose the query window contained:

SELECT TOP 1 * FROM MyTable

SELECT <field list=""> FROM MyTable
JOIN <join this="">
LEFT OUTER JOIN <join that="">
JOIN <join the="" other="">
WHERE <criteria>
AND <more criteria="">
AND <yet more="">
GROUP BY <my groups="">

SELECT <some things=""> FROM MyOtherTable WHERE TransDate = '5/1/2007'
AND TransCode IN (1,2,3)

SELECT <and so="" on="" and=""></and></some></my></yet></more></criteria></join></join></join></field>

Putting the text cursor ANYWHERE in the MyTable query and pressing the (1) shortcut would execute that entire SELECT. And putting it anywhere on the 1st line of the MyOtherTable query would execute that SELECT without the TransCode criteria.

I think this could make for a speedier research/development session in SSMS.