How to use correctly the Query Window in SQL Server 2008

Posted by Richard77 on Stack Overflow See other posts from Stack Overflow or by Richard77
Published on 2010-04-20T13:04:44Z Indexed on 2010/04/20 13:23 UTC
Read the original article Hit count: 308

Filed under:
|

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

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server-2008