Cargando…
Programming Microsoft SQL Server 2008 /
Provides programming instructions and code examples for Microsoft SQL Server 2008.
| Clasificación: | Libro Electrónico |
|---|---|
| Autores principales: | , , |
| Otros Autores: | , |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Redmond, Wash. :
Microsoft Press,
©2009.
|
| Colección: | Safari Books Online.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000Ma 4500 | ||
|---|---|---|---|
| 001 | OR_ocn298103750 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr zn||||||||| | ||
| 008 | 081119s2009 waua o 001 0 eng d | ||
| 010 | |a 2008935426 | ||
| 040 | |a YUS |b eng |e pn |c YUS |d COO |d OCLCQ |d UMI |d CEF |d B24X7 |d DEBSZ |d N$T |d OCLCQ |d FHM |d OCLCQ |d YDXCP |d OCLCQ |d OCLCF |d WYU |d UAB |d AU@ |d VT2 |d RDF |d OCLCO |d OCLCQ |d OCLCO | ||
| 019 | |a 311537275 |a 778655489 |a 1044254913 |a 1056379798 |a 1058099202 |a 1074323969 |a 1103266662 |a 1129331379 | ||
| 020 | |a 0735625999 | ||
| 020 | |a 9780735625990 | ||
| 020 | |a 9780735636293 |q (electronic bk.) | ||
| 020 | |a 073563629X |q (electronic bk.) | ||
| 020 | |a 9780735638198 |q (electronic bk.) | ||
| 020 | |a 0735638195 |q (electronic bk.) | ||
| 020 | |z 9780735625990 | ||
| 029 | 1 | |a CHBIS |b 006151298 | |
| 029 | 1 | |a CHVBK |b 17143515X | |
| 029 | 1 | |a DEBSZ |b 355426129 | |
| 029 | 1 | |a DEBSZ |b 378281194 | |
| 035 | |a (OCoLC)298103750 |z (OCoLC)311537275 |z (OCoLC)778655489 |z (OCoLC)1044254913 |z (OCoLC)1056379798 |z (OCoLC)1058099202 |z (OCoLC)1074323969 |z (OCoLC)1103266662 |z (OCoLC)1129331379 | ||
| 037 | |a CL0500000035 |b Safari Books Online | ||
| 050 | 4 | |a QA76.9.C55 |b L63 2009eb | |
| 072 | 7 | |a COM |x 021000 |2 bisacsh | |
| 072 | 7 | |a COM |x 084010 |2 bisacsh | |
| 072 | 7 | |a COM |x 030000 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.75/85 |2 22 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Lobel, Leonard. | |
| 245 | 1 | 0 | |a Programming Microsoft SQL Server 2008 / |c Leonard Lobel, Andrew J. Brust, Stephen Forte ; project editor, Kathleen Atkins ; technical reviewer, Kenn Scribner. |
| 260 | |a Redmond, Wash. : |b Microsoft Press, |c ©2009. | ||
| 300 | |a 1 online resource | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 520 | |a Provides programming instructions and code examples for Microsoft SQL Server 2008. | ||
| 505 | 0 | |a Programming Microsoft® SQL ServerTM 2008; Introduction; How This Book Is Organized; Code Samples and the Book's Companion Web Site; Using the Sample AdventureWorks2008 Databases; System Requirements; Support for This Book; I. Core Fundamentals; A Book for Developers; A Book by Developers; A Book to Show You the Way; Beyond Relational; Reaching Out; Business Intelligence Strategies; Summary; 2. T-SQL Enhancements; The PIVOT and UNPIVOT Operators; Dynamically Pivoting Columns; The APPLY Operator; TOP Enhancements; Ranking Functions; Grouping and Filtering with ROW_NUMBER; The RANK Function | |
| 505 | 8 | |a The DENSE_RANK and NTILE FunctionsUsing All the Ranking Functions Together; Ranking over Groups Using PARTITION BY; Exception Handling in Transactions; The varchar(max) Data Type; The WAITFOR Statement; DDL Triggers; SNAPSHOT Isolation; Table-Valued Parameters; Working with a Multiple-Row Set; Using TVPs for Bulk Inserts and Updates; Working with a Single Row of Data; Creating Dictionary-Style TVPs; Passing TVPs Using ADO.NET; TVP Limitations; New Date and Time Data Types; More Portable Dates and Times; Time Zone Awareness; Date and Time Accuracy, Storage, and Format | |
| 505 | 8 | |a New and Changed FunctionsThe MERGE Statement; The WHEN MATCHED Clause; The WHEN NOT MATCHED BY TARGET Clause; Using MERGE for Table Replication; The WHEN NOT MATCHED BY SOURCE Clause; MERGE Output; Choosing a Join Method; MERGE DML Behavior; Doing the ""Upsert""; The INSERT OVER DML Syntax; Consuming CHANGES; The GROUPING SETS Operator; Rolling Up All Level Combinations; Returning Just the Top Level; Mixing and Matching; Handling NULL Values; New T-SQL Shorthand Syntax; Summary; 3. Exploring SQL CLR; Visual Studio/SQL Server Integration; Automated Deployment; SQL CLR Code Attributes | |
| 505 | 8 | |a Your First SQL CLR Stored ProcedureCLR Stored Procedures and Server-Side Data Access; Deployment; Deploying Your Stored Procedures; Testing Your Stored Procedures; CLR Functions; CLR Triggers; CLR Aggregates; SQL CLR Types; Security; Examining and Managing SQL CLR Types in a Database; Best Practices for SQL CLR Usage; Summary; 4. Server Management; Latest Features in SMO; Working with SMO in Microsoft Visual Studio; Retrieving Server Settings; Creating Backup-and-Restore Applications; Progress Meter; Log Backup; Verify; Restore; Restoring to a Different Location | |
| 505 | 8 | |a Performing Programmatic DBCC Functions with SMOPolicy-Based Management; Summary; 5. Security in SQL Server 2008; Secure by Default; Secure by Deployment; Secure Communications; SQL Server 2008 Security Overview; Database Users; The guest User Account; Authentication and Authorization; Password Policies; User-Schema Separation; Execution Context; Encryption Support in SQL Server; Encrypting Data at Rest; Transparent Data Encryption in SQL Server 2008; Enabling TDE; Querying TDE Views; Backing Up the Certificate; Restoring an Encrypted Database; SQL Server Audit; Auditing Options; ON_FAILURE | |
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a SQL server. |
| 630 | 0 | 7 | |a SQL server. |2 blmlsh |
| 630 | 0 | 7 | |a SQL server |2 fast |
| 650 | 0 | |a Client/server computing. | |
| 650 | 0 | |a Programming (Computers) | |
| 650 | 6 | |a Architecture client-serveur (Informatique) | |
| 650 | 7 | |a COMPUTERS |x Database Management |x General. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Desktop Applications |x Databases. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x System Administration |x Storage & Retrieval. |2 bisacsh | |
| 650 | 7 | |a Client/server computing. |2 blmlsh | |
| 650 | 7 | |a Client/server computing |2 fast | |
| 650 | 7 | |a Engineering & Applied Sciences. |2 hilcc | |
| 650 | 7 | |a Computer Science. |2 hilcc | |
| 700 | 1 | |a Brust, Andrew J. |4 aut | |
| 700 | 1 | |a Forte, Stephen. |4 aut | |
| 700 | 1 | |a Atkins, Kathleen. |4 edt | |
| 700 | 1 | |a Scribner, Kenn. |4 rev | |
| 776 | 0 | 8 | |i Print version: |a Lobel, Leonard. |t Programming Microsoft SQL Server 2008. |d Redmond, Wash. : Microsoft Press, ©2009 |z 9780735625990 |w (DLC) 2008935426 |w (OCoLC)274184172 |
| 830 | 0 | |a Safari Books Online. | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9780735625990/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a EBSCOhost |b EBSC |n 431717 | ||
| 938 | |a YBP Library Services |b YANK |n 7485865 | ||
| 994 | |a 92 |b IZTAP | ||