SQL Server 2012 T-SQL Recipes : a Problem-Solution Approach /

Mostrar otras versiones (1)

"SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, se...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Brimhall, Jason
Otros Autores: Sheffield, Wayne, Roberts, Andy, Gennick, Jonathan, Dye, David
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Berkeley, CA : Apress : Imprint : Apress, 2012.
Colección:Expert's voice in SQL server.
Temas:
SQL server.
Database management.
Computer science.
Electronic Data Processing
Bases de données > Gestion.
Informatique.
COMPUTERS > Computer Literacy.
COMPUTERS > Computer Science.
COMPUTERS > Data Processing.
COMPUTERS > Hardware > General.
COMPUTERS > Information Technology.
COMPUTERS > Machine Theory.
COMPUTERS > Reference.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Getting Started with SELECT / Jonathan Gennick
  • Elementary Programming / Jonathan Gennick
  • NULLs and Other Pitfalls / Andy Roberts
  • Querying from Multiple Tables / Jonathan Gennick
  • Grouping and Summarizing / Wayne Sheffield
  • Advanced Select Techniques / Wayne Sheffield
  • Aggregations and Windowing / Wayne Sheffield
  • Inserting, Updating, Deleting / Andy Roberts
  • Working with Strings / Andy Roberts
  • Working with Dates and Times / Wayne Sheffield
  • Working with Numbers / Jonathan Gennick
  • Transactions, Locking, Blocking, and Deadlocking / Jason Brimhall
  • Managing Tables / Wayne Sheffield
  • Managing Views / Wayne Sheffield
  • Managing Large Tables and Databases / Wayne Sheffield
  • Managing Indexes / Jason Brimhall
  • Stored Procedures / Jonathan Gennick
  • User-Defined Functions and Types / Jason Brimhall
  • Triggers / Andy Roberts
  • Error Handling / David Dye
  • Query Performance Tuning / Jason Brimhall
  • Hints / Jonathan Gennick
  • Index Tuning and Statistics / Jason Brimhall
  • XML / Wayne Sheffield
  • Files, Filegroups, and Integrity / Wayne Sheffield
  • Backup / David Dye
  • Recovery / Jason Brimhall
  • Principals and Users / Jason Brimhall
  • Securables, Permissions, and Auditing / Jason Brimhall
  • Objects and Dependencies / Wayne Sheffield.

Ejemplares similares