Microsoft SQL Server 2005 Programming For Dummies (PDF)

Introduction. Part I: Get Started Using the SQL Server 2005 Development Environment. Chapter 1: The Joy of SQL Server 2005 Programming. Chapter 2: Understanding Database Fundamentals. Chapter 3: Getting to Know the SQL Server Toolset. Part II: Retrieving Data Using Transact-SQL. Chapter 4: Retrieving Data Using the SELECT Statement. Chapter 5: Creating Joins. Chapter 6: Creating Advanced Queries. Chapter 7: Manipulating Data. Part III: Creating Databases and Database Objects with Transact-SQL. Chapter 8: Designing, Creating, and Altering Database Objects. Chapter 9: Designing, Creating, and Changing Tables. Chapter 10: Applying Constraints. Chapter 11: Creating Views. Chapter 12: Using Stored Procedures. Chapter 13: Using Triggers. Chapter 14: Creating Functions. Chapter 15: Creating Indexes. Chapter 16: Handling Errors Using TRY . . . CATCH. Part IV: Programming SQL Server Security. Chapter 17: Adding Logins and Users. Chapter 18: Creating Database-Level Security. Chapter 19: Securing Data Using Encryption. Part V: Beyond Transact-SQL Programming. Chapter 20: Working with XML. Chapter 21: Working with the Common Language Runtime. Chapter 22: Using Visual Studio 2005. Chapter 23: Working with SQL Server Management Objects. Part VI: The Part of Tens. Chapter 24: Ten Tips to Program Like a Pro. Chapter 25: Ten Sources for More Information on SQL Server 2005. Index.

Andrew Watt wrote his first computer programs back in 1985.
He is an independent consultant, experienced author, and Microsoft
MVP (Most Valuable Professional) for SQL Server. His areas of
interest and expertise include SQL Server 2005, Windows PowerShell,
XML, and Microsoft InfoPath.

Andrew first used SQL Server in version 7.0 and was an active
participant in the SQL Server 2005 beta program from August
2003.

Among the books Andrew has written, or co-written, are SQL
Server 2005 For Dummies, Beginning Regular Expressions,
Beginning XML (3rd edition), Beginning RSS & Atom
Programming, Professional XML (2nd edition), and
Designing SVG Web Graphics.

Andrew is often seen answering questions in Microsoft's SQL
Server and other newsgroups. Feel free to get involved in the
community there. He can be contacted direct at
SVGDeveloper@aol.com. Due to the volume of e-mail he receives, he
can't guarantee to respond to every e-mail.

Dieses eBook können Sie uneingeschränkt auf allen Geräten der tolino Familie lesen. Zum Lesen auf sonstigen eReadern und am PC benötigen Sie eine Adobe ID.