|
Reference
Some useful charts and tables that you can refer to
SQLCMD Utility
SQLCMD is DOS command prompt utility introduced in 2005 that supersedes isql.exe and osql.exe. Like isql and osql, SQLCMD.exe can be used to execute T-SQL statements and scripts. Unlike isql and osql, SQLCMD has extensive support for scripting and variables. SQLCMD.exe uses OLE DB to connect and execute the T-SQL batches.
Last updated: 12/20/2004
Reserved
Keywords
Reserved Keywords are part of the grammar of the Transact-SQL language used by
SQL Server to parse and understand Transact-SQL statements and batches.
Although it is syntactically possible to use SQL Server reserved keywords as
identifiers and object names in Transact-SQL scripts, this can be done only
using delimited identifiers. It is recommended to not use the reserved keywords
as identifiers or object names.
Last updated: 7/20/2004
Catalog Views
There are many ways in which you can access SQL Server metadata. Using system tables (example: sysprocesses),
information schema views (example: INFORMATION_SCHEMA.TABLES), system stored procedures (example: sp_help, sp_who2),
and so on. The recommended, and most performance efficient way to access SQL Server metadata
is via the catalog views.
Last updated: 7/22/2004
Dynamic Management Views
Dynamic management views expose the current state of the SQL Server 2005 system.
They contain metadata that is not persisted on disk but stored in memory only.
Dynamic management views can be used to answer diagnostic questions.
Last updated: 7/22/2004
|