October 20, 2010 at 3:26 am
Hi All,
Is there a shortcut key, free plug-in, add-on or a something similar that I can use with SSMS (2005 or 2008) that can be used to run a batch of SQL script without first selecting it?
For example, I start SSMS, connect to a DB and open a new query window. Then lets say I write the following three SQL Scripts:
select getdate()
go
select *
from Employee
go
select col2, col4
from MyTable
go
If I wanted to run the second select statement, I would have to select the text and press F5. In many Oracle tools (SQL Developer for example) or any of the "TOAD for..." tools you do not need to do this. All you have to do is place the cursor on the script and press a shortcut key (most commonly F9). Although this might sound trivial I find it very annoying that I have to keep selecting each individual script. Especially if I have 5 to 10 scripts on a single page and each script is 10 or more lines.
October 20, 2010 at 4:59 am
Not that I know of, though I would bet @MladenPrajdic would be receptive to the idea of looking at including it in SSMS Tools Pack
regulars: Does Mladen post on here?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply