Sql Server 2000 Handbook

SQL Server 2000 Handbook

http://www.redware.com/handbooks/sql_server_handbook/sql_server_handbook_contents.html


sql server handbook

This 90 page book contains a comprehensive description of the major features of SQL Server 2000 and many technical notes on performance and programming issues.
The SQL Sever 2000 Handbook is now available online.
The book is designed for programmerswho need to look at the power of SQL Server beyond simple queries and data update applications. Most areas of SQL Server implementation are covered including:
• SQL Server Tools including the Enterprise Manager.
• SQL syntax including different methods for joining tables and complex select criteria involving sub-queries.
• Defining a database table and associated indexes andspecifying field properties, constraints, relationships between tables and referential integrity.
• Different views available including partitioned views and the integration of data from other database management systems.
• Stored procedures, the Transact-SQL programming language and parameters, output parameters, and return values.
• Using triggers to program business rules and datavalidation into the database management system.
• Optimisation techniques.
• Server configuration and security.
All topics are covered in a concise manner at a high level and the SQL Server Handbook is useful both as an introduction and as a reference used together with the full documentation from Microsoft.
|1. CONTENTS 3|6. INDEXES 43 |
|2. SQL SERVER OVERVIEW 6 | |
| |UNIQUE INDEX CONSTRAINT 43 |
|RELATIONALDATABASE TERMINOLOGY 6 | |
| |CLUSTERED INDEX 43 |
|SQL SERVER HISTORY 6 |7. VIEWS 45|
| | |
|Sybase 6 |INDEXED VIEWS 46 |
|| |
|SQL Server 4.2 6 |CHECK OPTION 46 |
| ||
|SQL Server 6.0 7 |PARTITIONED VIEWS 46 |
| | |
|SQL Server 6.5 7|OPENROWSET 47 |
| | |
|SQL Server 7.0 7 |LINKED SERVERS 47 |
|...