WritingStoredProceduresforMicrosoftSQLServer2000资源-CSDN文库

5星 · 超过95%的资源需积分: 9 22 浏览量 2008-05-10 11:06:17 上传评论收藏 1.13MB PDF 举报

资源推荐

资源详情

资源评论

Writing Stored Procedures for Microsoft SQL Server

Matthew Shepker

Publisher: Sams Publishing

First Edition June 30, 2000

ISBN: 0-672-31886-5, 360 pages

Introduction................................................................................................................5

Prerequisites...........................................................................................................5

System Requirements........................................................................................5

How This Book Is Organized............................................................................6

Part I: Introduction to Developing Stored Procedures..........................6

Part II: Simple Stored Procedures ................................................................6

Part III: Security and Advanced Procedure Development...................6

Part IV: XML and Triggers................................................................................7

Conventions Used in This Book ......................................................................7

Chapter 1. SQL Server and Stored Procedure Background.....................8

The History of Databases..................................................................................8

SQL Server's History...........................................................................................8

SQL Server in Business Today........................................................................9

Relational Database Management Systems.............................................10

The Features of SQL Server 2000...............................................................11

Uses for Stored Procedures............................................................................14

Conclusion.............................................................................................................15

Chapter 2. Stored Procedure Camps..............................................................16

What Is Business Logic?..................................................................................16

Why Differences Have Come About............................................................17

The All Business Logic Camp.........................................................................18

The No Business Logic Camp.........................................................................25

Finding Middle Ground .....................................................................................26

Conclusion.............................................................................................................27

Chapter 3. Processing Stored Procedures....................................................28

How SQL Server Creates Stored Procedures...........................................28

How SQL Server Processes Stored Procedures......................................29

Execution Plans...................................................................................................31

The Lazy Writer.......................................................................................................34

Viewing and Interpreting Execution Plans................................................36

Conclusion.............................................................................................................42

Chapter 4. Stored Procedures Rules...............................................................43

Programming Stored Procedure Rules.......................................................43

Using Naming Conventions ............................................................................49

Special Stored Procedure Naming Conventions.....................................55

Conclusion.............................................................................................................56

Chapter 5. Creating and Altering Stored Procedures...............................57

Creating Stored Procedures...........................................................................57

SELECT Statements............................................................................................58

Using Cursors.......................................................................................................68

CREATE PROCEDURE ............................................................................................73

The Changing of the Code—Altering Stored Procedures....................77

Alteration Considerations................................................................................83

Conclusion.............................................................................................................85

Chapter 6. Creating More Complex Stored Procedures....................................................86

Complex Stored Procedure Creation ..........................................................86

Passing Parameters into Stored Procedures............................................86

Returning Information to the User..............................................................90

Conclusion...........................................................................................................107

Chapter 7. Creating Stored Procedures that Insert Data.................................................108

Inserting Data with the INSERT Statement............................................108

Inserting Data into Views..............................................................................112

Inserting Data Based on a SELECT Statement......................................115

Inserting Data with an EXECUTE Statement...........................................116

Minimizing Blocking Conditions ..................................................................116

Automating the Creation of the Code......................................................119

Conclusion...........................................................................................................127

Chapter 8. Creating Stored Procedures that Modify Data..............................................128

Verifying the Data to Be Modified..............................................................128

Creating Procedures to Delete Data.........................................................135

Automating Code Creation ...........................................................................137

Conclusion...........................................................................................................149

Chapter 9. Providing Security for Stored Procedures.....................................................150

Security Basics..................................................................................................150

SQL Server Security........................................................................................150

Stored Procedures as a Security Mechanism........................................160

The SETUSER Function ........................................................................................164

Application Security.........................................................................................169

Ownership Chains ............................................................................................169

Conclusion...........................................................................................................170

Chapter 10. Programming Structures in SQL.................................................................171

Operators.............................................................................................................171

Looping Structures...........................................................................................176

Control-of-Flow Statements.........................................................................179

Functions.............................................................................................................183

Conclusion...........................................................................................................193

Chapter 11. Writing Utility Stored Procedures...............................................................194

Defining Utility Stored Procedures............................................................194

Utility Stored Procedure Code.....................................................................194

Conclusion...........................................................................................................242

Chapter 12. Extended Stored Procedures........................................................................243

How Extended Stored Procedures Work .................................................243

Writing the Required C Code.......................................................................246

Registering an Extended Stored Procedure...........................................253

Useful System Extended Stored Procedures.........................................254

Conclusion...........................................................................................................256

Chapter 13. Creating Custom Functions.........................................................................257

New Advances in SQL Server Functions..................................................257

User-Defined Functions..................................................................................258

Functions That Return a Table....................................................................263

Calling User-Defined Functions...................................................................266

Function Determinism....................................................................................268

Conclusion...........................................................................................................271

Chapter 14. SQL Server XML Support..........................................................................272

What Is XML?.....................................................................................................272

XML and HTML...................................................................................................273

Microsoft and XML............................................................................................275

XML Fundamentals...........................................................................................275

Using XML with SQL Server and Internet Information Server's

Server Extensions............................................................................................279

SQL XML...............................................................................................................283

The FOR XML Clause........................................................................................286

Formatting Data with XSL.............................................................................288

XML and Style Sheets.....................................................................................288

Putting It All Together....................................................................................289

Update Grams....................................................................................................293

Setting Basic Security ....................................................................................295

Security Configuration for URL Access ....................................................295

Conclusion...........................................................................................................297

Chapter 15. Writing Triggers..........................................................................................298

How Triggers Are Defined.............................................................................298

How Triggers Are Processed........................................................................299

Creating Triggers..............................................................................................301

Nested Triggers.................................................................................................314

剩余334页未读，继续阅读

评论收藏

内容反馈

c213x

2013-01-23

是一本可以迅速学习的书,上手容易,对于更深入的内容,需要自己再研究

gsut81

粉丝: 0
资源: 3

Writing Stored Procedures for Microsoft SQL Server 2000

最新资源

Writing Stored Procedures for Microsoft SQL Server 2000

List the Stored Procedures in a SQL Server database

SQL Server 2000 Procedures 教程完整版

SQL Server 2000 Stored Procedures Handbook

Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

SQL2000存储过程

Beginning T-SQL with Microsoft SQL Server 2005 and 2008

SQL Server 2008 R2详解手册.pdf

SQL Server T-SQL Recipes(Apress,4ed,2015)

Professional SQL Server 2005 CLR Programming with Stored Procedures, Functions, Triggers, Aggregates, and Types

SQL Server Stored Procedures, XML, and HTML(sample)

SQL Server Stored Procedures, XML, and HTML.pdf

[T-SQL] T-SQL 2008 程序员高级开发技术指南 (英文版)

[T-SQL] T-SQL 2012 程序员高级开发技术指南 (英文版)

PL/SQL详解 从入门到精通 英文版

Microsoft SQL Server 2008 Analysis Services Unleashed

unidac74.12d26-pro.rar for delphi 10.3.1

Murach's MySQL（第二版）

Mastering Entity Framework(PACKT,2015)

Devart_UniDAC_7.4.12_Professional_D7-D10.3_Rio_Full_Source_Code

Essential LINQ

Hibernate Reference Documentation3.1

Professional C# 3rd Edition

CSharp 3.0 With the .NET Framework 3.5 Unleashed（english）

C#学习的101个经典例子

hibernate3.6 文档（pdf 格式）

Qt 5实现串口调试助手 （源工程文件、0积分下载）

【SystemVerilog】路科验证V2学习笔记（全600页）.pdf

AutoSAR标准协议4.2.2

最新资源

PL/SQL详解从入门到精通英文版

Qt 5实现串口调试助手（源工程文件、0积分下载）