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

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

Πλήρης περιγραφή

Λεπτομέρειες βιβλιογραφικής εγγραφής
Κύριος συγγραφέας: Sack, Joseph (Συγγραφέας)
Συγγραφή απο Οργανισμό/Αρχή: SpringerLink (Online service)
Μορφή: Ηλεκτρονική πηγή Ηλ. βιβλίο
Γλώσσα:English
Έκδοση: Berkeley, CA : Apress, 2006.
Θέματα:
Διαθέσιμο Online:Full Text via HEAL-Link
Πίνακας περιεχομένων:
  • 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.