Using triggers to program business rules and data validation into the database management system.Īll 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. Stored procedures, the Transact-SQL programming language and parameters, output parameters, and return values. SQL syntax including different methods for joining tables and complex select criteria involving sub-queries.ĭefining a database table and associated indexes and specifying field properties, constraints, relationships between tables and referential integrity.ĭifferent views available including partitioned views and the integration of data from other database management systems. SQL Server 2000 Editions - Free download as Word Doc (.doc). SQL Server Tools including the Enterprise Manager. As such a database management system, it's a web-based application product with the sole purpose of storing and retrieving information as requested by third-party software programs across. Most areas of SQL Server implementation are covered including: Microsoft SQL Server is an integrated relational database management system (RDBMS) developed by Microsoft for use on Microsoft's SQL Server database servers. The book is designed for programmers who need to look at the power of SQL Server beyond simple queries and data update applications. The SQL Sever 2000 Handbook is now available online. 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.
