Description |
1 online resource (LV, 808 pages) |
|
text file |
|
PDF |
Series |
The expert's voice in SQL server |
|
Expert's voice in SQL server.
|
Contents |
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. |
Summary |
"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, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on."--Publisher website |
Subject |
SQL server. |
|
Database management.
|
|
Computer science.
|
|
Electronic Data Processing |
|
Bases de données -- Gestion. |
|
Informatique. |
|
Computer science |
|
Database management |
Added Author |
Sheffield, Wayne.
|
|
Roberts, Andy.
|
|
Gennick, Jonathan.
|
|
Dye, David.
|
Other Form: |
Print version: 9781430242000 |
ISBN |
9781430242017 (electronic bk.) |
|
1430242019 (electronic bk.) |
Standard No. |
10.1007/978-1-4302-4201-7 doi |
|