Solved

SSMS able to execute under cursor?

Posted on 2007-11-27
3
389 Views
Last Modified: 2010-03-19
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
Comment
Question by:iangregson1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 18

Accepted Solution

by:
Yveau earned 500 total points
ID: 20358386
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
 

Author Comment

by:iangregson1
ID: 20358696
cool! thank you..
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20359938
Glad I could be of any help !
0

Featured Post

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question