上流社会 发表于 2025-3-23 13:43:47
Tools of the Trade,Tool add-ins to Microsoft Visual Studio, SQL Profiler, Database Tuning Advisor, Extended Events, and SQL Server 2014 Books Online (BOL). You’re also introduced to supporting tools like SQL Server Integration Services (SSIS), the Bulk Copy Program (BCP), and the AdventureWorks 2014 sample database, which you use in examples throughout the book.demote 发表于 2025-3-23 13:52:37
User-Defined Functions,es that accept parameters, perform actions based on those parameters, and return data to the caller. T-SQL functions come in three flavors: inline table-valued functions (TVFs), multistatement TVFs, and scalar functions. SQL Server 2014 also supports the ability to create CLR integration UDFs, which are discussed in Chapter 15.Blood-Clot 发表于 2025-3-23 18:34:06
http://reply.papertrans.cn/76/7567/756681/756681_13.png朦胧 发表于 2025-3-24 00:41:00
Triggers,Definition Language (DDL) triggers, which fire in response to ., ., and . statements; and logon triggers, which fire in response to . events. DDL triggers can also fire in response to some system SPs that perform DDL-like operations.Notify 发表于 2025-3-24 05:06:28
http://reply.papertrans.cn/76/7567/756681/756681_15.pngSENT 发表于 2025-3-24 07:14:29
XQuery and XPath, XQuery, and modifying XML data via XML Data Modification Language (XML DML). This chapter focuses on how to get the most out of SQL Server’s implementation of the powerful and flexible XPath and XQuery standards.ASTER 发表于 2025-3-24 11:25:31
Catalog Views and Dynamic aent Views,Objects (SQL-DMO). Catalog views provide access to a richer set of detailed information than any of these options provided in previous SQL Server releases. SQL Server even includes catalog views that allow you to access server-wide configuration metadata.ALIBI 发表于 2025-3-24 18:30:27
http://reply.papertrans.cn/76/7567/756681/756681_18.png使无效 发表于 2025-3-24 21:37:13
Book 2015Latest editionL Server‘s database engine. This edition is updated to cover the new, in-memory features that are part of SQL Server 2014. Discussing new and existing features, the book takes you on an expert guided tour of Transact–SQL functionality. Fully functioning examples and downloadable source code bring te否认 发表于 2025-3-25 01:31:53
osoft SQL Server‘s database engine..Pro T–SQL Programmer’s Guide .is your guide to making the best use of the powerful, Transact-SQL programming language that is built into Microsoft SQL Server‘s database engine. This edition is updated to cover the new, in-memory features that are part of SQL Serve