Microsoft SQL Server 2000 Programming by Example

Front Cover
Que Publishing, 2001 - Computers - 771 pages

SQL Server 2000 Programming by Example provides clear and concise examples of basic programming techniques used in SQL Server 2000 primarily using Transact-SQL. Even if you're a complete novice to SQL Server 2000 programming, you will benefit by reading through the book's logical process. SQL Server 2000 is introduced and explored, database structure is designed and built, and finally a variety of programming techniques are studied and reviewed. If you are already familiar with SQL Server 2000 programming, you may use the book as a quick reference guide that provides plenty of pertinent examples.

 

What people are saying - Write a review

User Review - Flag as inappropriate

SQL Server 2000 programming fundamentals

Contents

Introduction
1
Relational Database Management Systems and SQL Server
7
Elements of TransactSQL
59
Working with Tables and Views
91
Querying and Modifying Data
121
JOINs
159
Indexes
187
How to Create Indexes
198
Programming Triggers
329
UserDefined Functions UDF
389
Using Complex Queries and Statements
463
Using Cursors
507
Transactions and Locks
553
Types of Locks
588
Transferring Data to and from SQL Server
617
Setting Up Linked
620

Table Scan
204
Covered Queries and Index Intersection
215
Indexes on Computed Columns
227
Summary
237
Enforcing Data Integrity
239
Programming Stored Procedures
295
Servers
665
A Using SQL Server Instances 703
666
B Using SQL Query Analyzer
721
Index
749
Copyright

Common terms and phrases

About the author (2001)

Carlos E. Rojas is the Database Administrator at Planeta Networks, in Miami, Florida. Prior to this DBA role, he was a consultant and trainer with Manapro in Caracas, Venezuela. He has participated as a speaker in various technet conferences in Venezuela.

Carlos has experience in developing Internet (n-tier) applications using Microsoft technologies, and implementing and administering SQL Server databases.

He is a Most Valuable Professional (MVP), Microsoft Certified Systems Engineer + Internet (MCSE+I), Microsoft Certified Database Administrator (MCDBA), and Microsoft Certified Sales Specialist (MCSS). He is also a voting member and volunteer of PASS, the professional association for SQL Server.

Fernando G. Guerrero is a Principal Technologist and SQL Server Product Consultant for QA Group Ltd., U.K. His main role involves IT training, course development, and internal mentoring. Fernando writes for SQL Server Magazine.

He has also presented a session on SQL Server 2000 at TechEd 2000 Europe, and has been accepted to speak at PASS, VBUG, Technology Week, VSLive, and SQL2THEMAX conferences during the year 2001.

He holds seven Microsoft Professional Certifications including MCSE+Internet, MCSD, MCDBA, and MCT, and has been awarded with the MVP (Most Valuable Professional) status on SQL Server.

Bibliographic information