Multiple commands on one line in SQL Server 2005

Question

I would like to execute multiple statements on one line in SQL Server 2005. How do I do the following on a single line:

use master
go
sp_spaceused mytable

When I try use master; go; sp_spaceused mytable I get Incorrect syntax near 'go'.

When I try use master go sp_spaceused mytable I get Incorrect syntax near 'go'.

Answer 1

use master; sp_spaceused mytable;

should suffice. GO simply signals the end of a batch of Transact-SQL statements to the SQL Server utilities.

Answer 2

You don't need GO. Just use ;