How to use correctly the Query Window in SQL Server 2008

Question

Hello,

What should I do to avoid that commands be executed each time I hit 'Execute !. icon'

I mean this

USE master;
GO
CREATE DATABASE Sales
GO
USE Sales;
GO
CREATE TABLE Customers(
CustomerID int NOT NULL,
LName varchar (50) NOT NULL,
FName varchar (50) NULL,
Status varchar (10),
ModifiedBy varchar (30) NULL        
    )
GO

When I click Execute!, Sql Server tries to redo the same thing.

What I do for now is to delete the Query Window completely then write what I need before clicking the Execute icon. But, I doubt that I should be doing that.

What can I do to keep writing the commands without having each time to clear the Query Window?

Thanks for helping

Answer 1

You can highlight the command you wish to run prior to hitting execute and it will only run the selected query text, alternatively you can comment a single line out with a double dash sign e.g. -- , or comment a block of text out with /* */

Answer 2

As far as I know there are only two option:

• ctr + a en then delete
• open a new query window

Answer 3

New Query Window

Use Control+N to create a new window, write your query in there.

SELECT what you want

Click the Right Mouse button and drag to select what you want to execute, then execute the query