Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 392
  • Last Modified:

SSMS able to execute under cursor?

Hi there,

does anyone know if SSMS is it possible to have a query window open with many lines of scripts but just execute a line under the cursor for exmaple?

I have been using TOAD (for oracle) for quite a while and now coming back to SQL server i am trying to get used to SSMS but i don't find this kind of functionality..

Do i have to create new windows....??

I normally have quite a lot of sql statements in 1 windows and just execute the bit i need

Any advise realyl apprecaited

Thanks
0
iangregson1
Asked:
iangregson1
  • 2
1 Solution
 
YveauCommented:
Yes, just select the section of code you want to execute and enter CTRL+E
... or select 'execute' from the toolbar.

Hope this helps ...
0
 
iangregson1Author Commented:
cool! thank you..
0
 
YveauCommented:
Glad I could be of any help !
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now