How to use correctly the Query Window in SQL Server 2008
- by Richard77
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