| 000 -LEADER |
|---|
| fixed length control field |
03804cam a2200301 a 4500 |
| 001 - CONTROL NUMBER |
|---|
| control field |
u2804 |
| 003 - CONTROL NUMBER IDENTIFIER |
|---|
| control field |
SA-PMU |
| 005 - DATE AND TIME OF LATEST TRANSACTION |
|---|
| control field |
20210418124617.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
|---|
| fixed length control field |
090316s2008 caua 001 0 eng d |
| 010 ## - LIBRARY OF CONGRESS CONTROL NUMBER |
|---|
| LC control number |
2009277025 |
| 040 ## - CATALOGING SOURCE |
|---|
| Original cataloging agency |
YDXCP |
| Transcribing agency |
YDXCP |
| Modifying agency |
DLC |
| -- |
CDN |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
9781430210016 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
143021001X |
| 035 ## - SYSTEM CONTROL NUMBER |
|---|
| System control number |
(OCoLC)231895215 |
| 042 ## - AUTHENTICATION CODE |
|---|
| Authentication code |
lccopycat |
| 050 00 - LIBRARY OF CONGRESS CALL NUMBER |
|---|
| Classification number |
QA76.73.S67 |
| Item number |
C653 2008 |
| 082 04 - DEWEY DECIMAL CLASSIFICATION NUMBER |
|---|
| Classification number |
005.756 |
| Edition number |
22 |
| 100 1# - MAIN ENTRY--PERSONAL NAME |
|---|
| Personal name |
Coles, Michael, |
| Dates associated with a name |
1972- |
| 245 10 - TITLE STATEMENT |
|---|
| Title |
Pro T-SQL 2008 : |
| Remainder of title |
programmer's guide / |
| Statement of responsibility, etc. |
Michael Coles. |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. |
|---|
| Place of publication, distribution, etc. |
Berkeley, CA : |
| Name of publisher, distributor, etc. |
Apres, |
| Date of publication, distribution, etc. |
2008 |
| 300 ## - PHYSICAL DESCRIPTION |
|---|
| Extent |
xxviii, 659 p. : |
| Other physical details |
ill. ; |
| Dimensions |
24 cm. |
| 500 ## - GENERAL NOTE |
|---|
| General note |
Includes index. |
| 505 0# - FORMATTED CONTENTS NOTE |
|---|
| Formatted contents note |
Cover -- Copyright -- Dedication -- Contents at a Glance -- TOC$Contents -- About the Author -- About the Technical Reviewer -- Acknowledgments -- Introduction -- CH$1 Foundations of T-SQL -- A Short History of T-SQL -- Imperative vs. Declarative Languages -- SQL Basics -- Statements -- Databases -- Transaction Logs -- Schemas -- Tables -- Views -- Indexes -- Stored Procedures -- User-Defined Functions -- SQL CLR Assemblies -- Elements of Style -- Whitespace -- Naming Conventions -- One Entry, One Exit -- Defensive Coding -- SQL-92 Syntax Outer Joins -- The SELECT * Statement -- Variable Initialization -- Summary -- CH$2 T-SQL 2008 New Features -- Productivity Enhancements -- The MERGE Statement -- New Data Types -- Date and Time Data Types -- The hierarchyid Data Type -- hierarchyid Methods -- Spatial Data Types -- Grouping Sets -- Other New Features -- Summary -- CH$3 Tools of the Trade -- SQL Server Management Studio -- SSMS Editing Options -- Context-Sensitive Help -- Graphical Query Execution Plans -- Project Management Features -- The Object Explorer -- The SQLCMD Utility -- Business Intelligence Development Studio -- SQL Profiler -- SQL Server Integration Services -- The Bulk Copy Program -- SQL Server 2008 Books Online -- The AdventureWorks Sample Database -- Summary -- CH$4 Procedural Code and CASE Expressions -- Three-Valued Logic -- Control-of-Flow Statements -- The BEGIN and END Keywords -- The IF...ELSE Statement -- The WHILE, BREAK, and CONTINUE Statements -- The GOTO Statement -- The WAITFOR Statement -- The RETURN Statement -- The TRY...CATCH Statement -- The CASE Expression -- The Simple CASE Expression -- The Searched CASE Expression -- CASE and Pivot Tables -- COALESCE and NULLIF -- Cursors -- Summary -- CH$5 User-Defined Functions -- Scalar Functions -- Recursion in Scalar User-Defined Functions -- Procedural Code in User-Defined Functions -- Multistatement Table-Valued Functions -- Inline Table-Valued Functions -- Restrictions on User-Defined Functions -- Nondeterministic Functions -- State of the Database -- Summary -- CH$6 Stored Procedures -- Introducing Stored Procedures -- Calling Stored Procedures -- Managing Stored Procedures -- Stored Procedures in Action -- Recursion in Stored Procedures -- Table-Valued Parameters -- Temporary Stored Procedures -- Recompilation and Caching -- Stored Procedure Statistics -- Parameter Sniffing -- Recompilation -- Summary -- CH$7 Triggers -- DML Triggers -- When to Use DML Triggers -- Auditing with DML Triggers -- Nested and Recursive Triggers -- The UPDATE and COLUMNS_UPDATED Functions -- Triggers on Views -- DDL Triggers -- Logon Triggers -- Summary -- CH$8 Encryption -- The Encryption Hierarchy -- Service Master Keys -- Database Master Keys -- Certificates -- Asymmetric Keys -- Symmetric Keys -- Encryption Without Keys -- Hashing Data -- Extensible Key Management -- Transparent Data Encryption -- Summary -- CH$9 Common Table Expressions and Windowing Functions -- Common Table Expressions -- Mult. |
| 596 ## - |
|---|
| -- |
1 2 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
SQL (Computer program language) |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) |
|---|
| Koha item type |
Books |
| 994 ## - |
|---|
| -- |
Z0 |
| -- |
SUPMU |