000			03804cam a2200301 a 4500
001			u2804
003			SA-PMU
005			20210418124617.0
008			090316s2008 caua 001 0 eng d
010			_a 2009277025
040			_aYDXCP _cYDXCP _dDLC _dCDN
020			_a9781430210016
020			_a143021001X
035			_a(OCoLC)231895215
042			_alccopycat
050	0	0	_aQA76.73.S67 _bC653 2008
082	0	4	_a005.756 _222
100	1		_aColes, Michael, _d1972-
245	1	0	_aPro T-SQL 2008 : _bprogrammer's guide / _cMichael Coles.
260			_aBerkeley, CA : _bApres, _c2008
300			_axxviii, 659 p. : _bill. ; _c24 cm.
500			_aIncludes index.
505	0		_aCover -- 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.
650		0	_aSQL (Computer program language)
942			_cBOOK
994			_aZ0 _bSUPMU
596			_a1 2
999			_c8763 _d8763