Solved

SSMS able to execute under cursor?

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Delete from table 6 47
Grid querry results 41 80
Query to Add Late Tolerance 10 76
Restrict result set 1 39
In this article I will describe the Copy Database Wizard 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.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

792 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