Daniel

← Customer Feedback for ACE Community Tooling

My feedback

SSMS:Add a Keyboard Shortcut that Executes the Statement where the Cursor is placed

453 votes

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea

14 comments · SQL Server » Suggestions · Flag idea as inappropriate… · Delete… · Admin →

planned · AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) responded

We’ll look at this for future release.

Daniel shared this idea · February 01, 2018
Execute Current Statement

5 votes

Sign in
prestine

(thinking…)

Sign in with: Microsoft

Forgot password?

Create a password

I agree to the terms of service

Signed in as (Sign out)

Close

Close

We’ll send you updates on this idea

2 comments · SQL Server » Suggestions · Flag idea as inappropriate… · Delete… · Admin →

unplanned · AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) responded

Upvotes: 7
<=-=Jun 6 2005 8:24AM=-=>
Thank you for your suggestion regarding executing a statement without having to select it. We will consider this for future releases.
Bill Ramos
<=-=Oct 11 2006 5:59PM=-=>
This hasn’t made it into a service pack, but we’re still considering this item for a future release of SQL Server.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
<=-=Dec 3 2007 8:32AM=-=>
Although we won’t be able to provide this functionality for SQL Server 2008, we can consider it for a future release based on overall customer demand.

Thanks,
Ken Van Hyning
<=-=Aug 5 2009 4:28AM=-=>
Hello,
Like the OP I’ve used TOAD and been really impressed with this feature. Would really like to have this in SSMS.

I raised a forum thread on it prior to coming here: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/4fcd052d-a2db-4431-b80f-9a2ca278ff8a/

This submisison is now 4 years old – is it worth my raising it again?
-Jamie
<=-=Apr 21 2011 7:26AM=-=>
I’m not sure about this one. Until everyone is always ending every single statement with a proper terminator (;) it can become very messy trying to figure out what the “current statement” is.

The feature in the PowerShell ISE always throws me off but in the other direction. You can highlight a line of code but if you hit F5 it still executes everything, because you didn’t choose the “exec current statement” option.

I prefer the way SSMS does it today. F5 always executes exactly what you have selected.
<=-=Apr 9 2013 3:27PM=-=>
Not just Toad, but every other visual SQL Query tool I’ve used over the past few years against Oracle, Sybase – even DB2 – has some way to do this. Don’t get me wrong – I am very happy to be back working with MSSQL, but I was actually shocked that this seemly simple feature still hasn’t made it into production.

Not suggesting you change the default function of F5 or Ctrl-E, but please give us some other shortcut to access this behaviour: CRTL-ALT-SHIFT whatever would be fine.

For the comments below referring to people not terminating their statements correctly, the expected behaviour in these other tools (and by the way – some of them are terrible) is that if the current statement can’t be identified, then error – pretty much the same thing that would happen if you try to run a collection of un-terminated statements.

Upvotes: 7
<=-=Jun 6 2005 8:24AM=-=>
Thank you for your suggestion regarding executing a statement without having to select it. We will consider this for future releases.
Bill Ramos
<=-=Oct 11 2006 5:59PM=-=>
This hasn’t made it into a service pack, but we’re still considering this item for a future release of SQL Server.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
<=-=Dec 3 2007 8:32AM=-=>
Although we won’t be able to provide this functionality for SQL Server 2008, we can consider it for a future release based on overall customer demand.

Thanks,
Ken Van Hyning
<=-=Aug 5 2009 4:28AM=-=>
Hello,
Like the OP I’ve used TOAD and been really impressed with this feature. Would really like to have this in SSMS.

I raised a forum thread on it prior to coming here: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/4fcd052d-a2db-4431-b80f-9a2ca278ff8a/

This submisison is now 4 years old – is it worth my…

Daniel supported this idea · February 01, 2018

Daniel

My feedback

SSMS:Add a Keyboard Shortcut that Executes the Statement where the Cursor is placed

Execute Current Statement

Feedback and Knowledge Base

Searching…

Give feedback

Microsoft Azure

Your password has been reset