• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 236
  • Last Modified:

sql server management studio questions with regards to attaching and using GO?

Hi there,

I have been using the sql server management studio (express) and i would like to know what the difference is of creating a db in the studio or creating in VS 2005... it appears that one is attached and the other isn't?

What are the pros and cons of the 2 different ways?

Also when i write queries etc in sqlcmd.. i use GO to execute the command/s ...but in SQL Management studio is there any point to GO?? As you click the EXECUTE button on the toolbar to execute the script which i assume executes ALL of the script not just the current line

If anybody can confirm anything i would be really grateful..

thansk
0
iangregson1
Asked:
iangregson1
  • 4
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
Hello iangregson1,
Management studio is the IDE for SQL
GO - indicates the end of a batch ,the variables declared above wont be available for the statements beneath tht 'GO'


Aneesh R
0
 
Jaime OlivaresCommented:
0
 
iangregson1Author Commented:
Hi thanks for the reply, but it is totally valid to do the following in SSMS

command
GO

command
GO
etc

it sqlcmd GO executes the statements.. but in SSMS when you click execute it seems that ALL statements are executed weather or not the GO is there??

0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
iangregson1Author Commented:
Ermm maybe i didn't explain myself correctly, ok is SSMS .. if i put this into a query window .. i get 2 resultsets back... but i didn't use GO??  So what is the difference?  I just click the EXECUTE .. and all 3 commands are evaluated and run...

USE test;

SELECT * FROM dbo.Table_1 WHERE test='1';

SELECT * FROM dbo.Table_1 WHERE test='2';

0
 
iangregson1Author Commented:
I even tried this... and the execute sure enough EXECUTES all commands.. with or without a GO

USE test;

SELECT * FROM dbo.Table_1 WHERE test='1';

SELECT * FROM dbo.Table_1 WHERE test='2';

GO


SELECT * FROM dbo.Table_1 WHERE test='4';
0
 
iangregson1Author Commented:
Oh i think i found, can anyone confirm it for me..

If you make 4 statements into one batch like this --

statement1; statement2; statement3; statement4 GO

....and statement4 fails with an error, the affected objects are
restored to the way they were before statement1.   so if 4 FAILS then ALL fails!

If you make them 4 separate batches like this --

statement1 GO statement2 GO statement3 GO statement4 GO

.... and statement4 fails with an error, the objects are restored to
the way they were after statement 3.

So i presume a long script without using GO then  if something failed ... they would all get returned to how they were before??? Pretty much like putting a GO at the end of a script...??

Any advise really appreciated
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now