Description: SQL Server 2000 Programming by Example provides clear and concise examples of basic programming techniques used in SQL Server 2000 primarily using Transact-SQL. Readers that consider themselves complete novices to SQL Server 2000 programming will benefit by reading the book from cover to cover. This leads the reader through a logical process by which SQL Server 2000 is introduced and explored, database structure is designed and built, and finally a variety of programming techniques are studied and reviewed. Readers that are already familiar with SQL Server 2000 programming may use the book as a quick reference guide that provides plenty of pertinent examples.
-- Introduction to SQL Server 2000
-- Important Database Concepts
-- The Databases of SQL Server 2000
-- Using SQL Server 2000 Databases
-- Creating Structure
-- Working with Tables
-- The Basics of SQL Server 2000 Programming
-- Stored Procedures
-- Triggers
-- Views
-- Transactions
-- Advanced Querying Techniques
-- Cursors
-- Security Basics in SQL Server 2000.

Please Wait