SQL Management Studio - Execute current line

Posted by mawaldne on Stack Overflow See other posts from Stack Overflow or by mawaldne
Published on 2010-04-16T20:31:34Z Indexed on 2010/04/16 20:43 UTC
Read the original article Hit count: 397

Filed under:

sql-server-management-stu

In SQL Server 2008 Management studio, I can hit F5 to execute everything in the current query window. I can also highlight a query, and hit F5 to run that highlighted query.

Instead of having to highlight a query, is there a way I can run the single query my cursor is on, or run a query my cursor is on up to a the first ';'?

Related posts about sql-server-management-stu

Why is SQL Server Compact Edition missing from the list of server types in SQL Server Management Stu

as seen on Stack Overflow - Search for 'Stack Overflow'
I have both 'SQL Server Compact 3.5 Service Pack 1' and 'SQL Server Management Studio 2008' (SSMS) installed on my PC. In the past, I was able to select 'SQL Server Compact Edition' from the list of 'Server Types' in the 'Connect to Server' dialog within SSMS. This entry is now missing and I have… >>> More
SQL SERVER – Generate Report for Index Physical Statistics – SSMS

as seen on SQL Authority - Search for 'SQL Authority'
Few days ago, I wrote about SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS (Link). A user asked me a question regarding if we can use similar reports to get the detail about Indexes. Yes, it is possible to do the same. There are similar type of reports are available at Database… >>> More
SQL SERVER – Out of the Box – Activty and Performance Reports from SSSMS

as seen on SQL Authority - Search for 'SQL Authority'
SQL Server management Studio 2008 is wonderful tool and has many different features. Many times, an average user does not use them as they are not aware about these features. Today, we will learn one such feature. SSMS comes with many inbuilt performance and activity reports, but we do not use it… >>> More
SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

as seen on SQL Authority - Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL… >>> More
SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video

as seen on SQL Authority - Search for 'SQL Authority'
SQL Server management Studio 2012 is wonderful tool and has many different features. Many times, an average user does not use them as they are not aware about these features. Today, we will learn one such feature. SSMS comes with many inbuilt performance and activity reports, but we do not use it… >>> More

Developer IT

SQL Management Studio - Execute current line - Developer IT

SQL Management Studio - Execute current line

sql-server-management-stu

Related posts about sql-server-management-stu

Why is SQL Server Compact Edition missing from the list of server types in SQL Server Management Stu

SQL SERVER – Generate Report for Index Physical Statistics – SSMS

SQL SERVER – Out of the Box – Activty and Performance Reports from SSSMS

SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video

Categories cloud