Professional SQL server 2005 programming / Robert Vieira.

Format:

Book

Author/Creator:

Vieira, Robert.

Series:

Wrox professional guides.

Wrox professional guides

Language:

English

Subjects (All):

SQL server.

Client/server computing.

Database management.

Genre:

Electronic books.

Physical Description:

1 online resource (914 p.)

Edition:

1st edition

Place of Publication:

Indianapolis, IN : Wiley Publishing, c2007.

Language Note:

English

System Details:

text file

Summary:

Professional SQL Server 2005 Programming shows experienced developers how to master the substantially revamped feature set of the latest release of Microsoft SQL Server. The book begins with a concise overview of the new features of SQL Server that is of interest to experienced developers. This is especially important given the substantial changes to SQL Server with this release. From there, the book quickly moves on to the ?meat? of the title. Beginning-level material has been removed to provide more room for covering new features and more extensive code examples.

Contents:

Professional SQL Server 2005 Programming; Credits; About the Author; Acknowledgments; Contents; Introduction; Version Issues; Who This Book Is For; What This Book Covers; How This Book Is Structured; Feedback; What You Need to Use This Book; Conventions; Source Code; Errata; p2p.wrox.com; Chapter 1: Being Objective: Re-Examining Objects in SQL Server; So, What Exactly Do We Have Here?; An Overview of Database Objects; SQL Server Data Types; SQL Server Identifiers for Objects; Summary; Chapter 2: Tool Time; Books Online; The SQL Server Configuration Manager; The SQL Server Management Studio

SQL Server Business Intelligence Development StudioSQL Server Integration Services (SSIS); Reporting Services; Bulk Copy Program (BCP); SQL Server Profiler; sqlcmd; Summary; Chapter 3: Basic T-SQL; The Basic SELECT Statement; Adding Data with the INSERT Statement; Changing What You've Got with the UPDATE Statement; The DELETE Statement; Exploring Alternative Syntax for Joins; The UNION; Summary; Chapter 4: Creating and Altering Tables; Object Names in SQL Server; The CREATE Statement; The ALTER Statement; The DROP Statement; Using the GUI Tool; Summary

Chapter 5: Reviewing Keys and ConstraintsTypes of Constraints; Constraint Naming; Key Constraints; CHECK Constraints; DEFAULT Constraints; Disabling Constraints; Rules and Defaults: Cousins of Constraints; Triggers for Data Integrity; Choosing What to Use; Summary; Chapter 6: Asking a Better Question: Advanced Queries; What Is a Subquery?; Building a Nested Subquery; Correlated Subqueries; Derived Tables; The EXISTS Operator; Mixing Data Types: CAST and CONVERT; Using External Calls to Perform Complex Actions; Performance Considerations; Summary; Chapter 7: Daring to Design; Normalization 201

RelationshipsDiagramming; Logical versus Physical Design; Dealing with File-Based Information; Subcategories; Database Reuse; De-Normalization; Par titioning for Scalability; The SQL Server Diagramming Tools; Summary; Chapter 8: SQL Server - Storage and Index Structures; SQL Server Storage; Understanding Indexes; Creating, Altering, and Dropping Indexes; Choosing Wisely: Deciding What Index Goes Where and When; Maintaining Your Indexes; Summary; Chapter 9: Views; Simple Views; More Complex Views; Editing Views with T-SQL; Dropping Views; Auditing: Displaying Existing Code

Protecting Code: Encrypting ViewsAbout Schema Binding; Making Your View Look Like a Table with VIEW_ METADATA; Indexed (Materialized) Views; Partitioned Views; Summary; Chapter 10: Scripts and Batches; Script Basics; Batches; SQLCMD; Dynamic SQL: Generating Your Code on the Fly with the EXEC Command; Control-of-Flow Statements; Summary; Chapter 11: Getting Procedural: Stored Procedures and User-Defined Functions; Creating the Sproc: Basic Syntax; Changing Stored Procedures with ALTER; Dropping Sprocs; Parameterization; Confirming Success or Failure with Return Values; Dealing with Errors

What a Sproc Offers

Notes:

"Programmer to programmer"--Cover.

Includes index.

ISBN:

9786610740369

9781280740367

1280740361

9780470106211

0470106212

OCLC:

86105713