/table>
SPS Home    >   Dgreath    >   RDBMS    >   SQL Commands

SQL Commands

The following SQL Server commands are executed within a connected instance of Query Analyzer or SQL Management Studio:
DBCC function (attributes)
used to perform a variety of administrative functions.
EXEC sp_something
used to execute stored procedures
GO
used to force execution of all SQL statements entered up to that point.

USE dbname
establishes the database context for all subsequent operations until changed by another USE command.  This is the database name created by the CREATE DATABASE name attribute. Until specified, the system "master" database is active.