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...
Κύριος συγγραφέας: | |
---|---|
Συγγραφή απο Οργανισμό/Αρχή: | |
Μορφή: | Ηλεκτρονική πηγή Ηλ. βιβλίο |
Γλώσσα: | 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.