SQL Server 2005 T-SQL Recipes A Problem-Solution Approach /

SQL Server 2005 T-SQL Recipes A Problem-Solution Approach /

Show other versions (1)

Need to brush up on specific SQL Server tasks, procedures, or Transact-SQL commands? Not finding what you need from SQL Server books online? Or perhaps you just want to familiarize yourself with the practical application of new T-SQL related features. SQL Server 2005 T-SQL Recipes: A Problem-Solutio...

Full description

Bibliographic Details
Main Author: Sack, Joseph (Author)
Corporate Author: SpringerLink (Online service)
Format: Electronic eBook
Language:English
Published: Berkeley, CA : Apress, 2006.
Subjects:
Computer science.
Software engineering.
Computer Science.
Software Engineering/Programming and Operating Systems.
Online Access:Full Text via HEAL-Link
Table of Contents:
  • Select
  • Insert, Update, Delete
  • Transactions, Locking, Blocking, and Deadlocking
  • Tables
  • Indexes
  • Full-Text Search
  • Views
  • SQL Server Functions
  • Conditional Processing, Control-of-Flow, and Cursors
  • Stored Procedures
  • User-Defined Functions and Types
  • Triggers
  • CLR Integration
  • XML
  • Web Services
  • Error Handling
  • Principals
  • Securables and Permissions
  • Encryption
  • Service Broker
  • Configuring and Viewing SQL Server Options
  • Creating and Configuring Databases
  • Database Integrity and Optimization
  • Maintaining Database Objects and Object Dependencies
  • Database Mirroring
  • Database Snapshots
  • Linked Servers and Distributed Queries
  • Performance Tuning
  • Backup and Recovery.

Similar Items