Solved

SSMS able to execute under cursor?

Posted on 2007-11-27
3
386 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

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 this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

749 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