This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL)-one of the most familiar and powerful programming languages for SQL Server. Written by a T-SQL guru, this guide focuses on language features and how they are interpreted and processed by the SQL Server execution engine. You'll get in-depth coverage of the sophisticated uses of T-SQL, including triggers, user-defined functions, exception handling, and more. The book explains and compares solutions to database-development problems in both SQL Server 2000 and SQL Server 2005, discussing the new T-SQL programming features added to SQL Server
Edición: Microsoft Press (2006)
Idioma: Inglés
Formato: PDF
Contenido:
- Datatype-Related Problems, XML, and CLR UDTs
- Temporary Tables and Table Variables
- Cursors
- Dynamic SQL
- Views
- User-Defined Functions
- Stored Procedures
- Triggers
- Transactions
- Exception Handling
- Service Broker
- Appendix A: Companion to CLR Routines
Descarga/Download
No hay comentarios:
Publicar un comentario