Professional SQL server 2005 programming /

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 e...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Vieira, Robert
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, IN : Wiley Technology Pub., ©2007.
Colección:Wrox professional guides.
Temas:
SQL server.
SQL server
Client/server computing.
SQL Server.
Architecture client-serveur (Informatique)
REFERENCE > General.
Client/server computing
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Cover
  • Credits
  • About the Author
  • Acknowledgments
  • TOC36;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
  • p2p46;wrox46;com
  • CH36;Chapter 158; Being Objective58; Re45;Examining Objects in SQL Server
  • So44; What Exactly Do We Have Here63;
  • An Overview of Database Objects
  • SQL Server Data Types
  • SQL Server Identifiers for Objects
  • Summary
  • CH36;Chapter 258; Tool Time
  • Books Online
  • The SQL Server Configuration Manager
  • The SQL Server Management Studio
  • SQL Server Business Intelligence Development Studio
  • SQL Server Integration Services 40;SSIS41;
  • Reporting Services
  • Bulk Copy Program 40;BCP41;
  • SQL Server Profiler
  • sqlcmd
  • Summary
  • CH36;Chapter 358; Basic T45;SQL
  • The Basic SELECT Statement
  • Adding Data with the INSERT Statement
  • Changing What You8217;ve Got with the UPDATE Statement
  • The DELETE Statement
  • Exploring Alternative Syntax for Joins
  • The UNION
  • Summary
  • CH36;Chapter 458; Creating and Altering Tables
  • Object Names in SQL Server
  • The CREATE Statement
  • The ALTER Statement
  • The DROP Statement
  • Using the GUI Tool
  • Summary
  • CH36;Chapter 558; Reviewing Keys and Constraints
  • Types of Constraints
  • Constraint Naming
  • Key Constraints
  • CHECK Constraints
  • DEFAULT Constraints
  • Disabling Constraints
  • Rules and Defaults58; Cousins of Constraints
  • Triggers for Data Integrity
  • Choosing What to Use
  • Summary
  • CH36;Chapter 658; Asking a Better Question58; Advanced Queries
  • What Is a Subquery63;
  • Building a Nested Subquery
  • Correlated Subqueries
  • Derived Tables
  • The EXISTS Operator
  • Mixing Data Types58; CAST and CONVERT
  • Using External Calls to Perform Complex Actions
  • Performance Considerations
  • Summary
  • CH36;Chapter 758; Daring to Design
  • Normalization 201
  • Relationships
  • Diagramming
  • Logical versus Physical Design
  • Dealing with File45;Based Information
  • Subcategories
  • Database Reuse
  • De45;Normalization
  • Par titioning for Scalability
  • The SQL Server Diagramming Tools
  • Summary
  • CH36;Chapter 858; SQL Server 8212; Storage and Index Structures
  • SQL Server Storage
  • Understanding Indexes
  • Creating44; Altering44; and Dropping Indexes
  • Choosing Wisely58; Deciding What Index Goes Where and When
  • Maintaining Your Indexes
  • Summary
  • CH36;Chapter 958; Views
  • Simple Views
  • More Complex Views
  • Editing Views with T45;SQL
  • Dropping Views
  • Auditing58; Displaying Existing Code
  • Protecting Code58; Encrypting Views
  • About Schema Binding
  • Making Your View Look Like a Table with VIEW_ METADATA
  • Indexed 40;Materialized41; Views
  • Partitioned Views
  • Summary
  • CH36;Chapter 1058; Scripts and Batches
  • Script Basics
  • Batches
  • SQLCMD
  • Dynamic SQL58; Generating Your Code on the Fly with the EXEC Command
  • Control45;of45;Flow Statements
  • Summary
  • CH36;Chapter 1158; Getting Procedural58; Stored Procedures and User45;Defined Functions
  • Creating the Sproc58; Bas.

Ejemplares similares