Muutke küpsiste eelistusi

E-raamat: SQL Server 2000 Stored Procedures Handbook

, , ,
  • Formaat: PDF+DRM
  • Ilmumisaeg: 09-Nov-2013
  • Kirjastus: APress
  • Keel: eng
  • ISBN-13: 9781430211259
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 37,04 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
SQL Server 2000 Stored Procedures HandbookSuurem pilt
  • Formaat: PDF+DRM
  • Ilmumisaeg: 09-Nov-2013
  • Kirjastus: APress
  • Keel: eng
  • ISBN-13: 9781430211259
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Stored procedures are compiled T-SQL statements that reside on the database. They are the cornerstones of successful data manipulation, and data-handling operations of every complexity make use of them. This book is an in-depth guide to a key area of database development.



This book tackles real-world problems faced by developers when working with stored procedures, showing you how to solve these problems, avoid the common pitfalls, and produce faster, more robust stored procedures. Put simply: if you want to write better stored procedures, then this is the book for you.

Muu info

Springer Book Archives
Introduction 1(1)
Who Is This Book For?
1(1)
Book Outline
2(3)
Stored Procedures Overview
5(30)
What is a Stored Procedure?
6(5)
System Stored Procedure
6(2)
User Stored Procedure
8(1)
Creating Stored Procedures
9(2)
Performance Consideration
11(1)
Network Consideration
11(1)
Why Use Stored Procedures?
11(1)
Replication
12(1)
Designing Good Stored Procedures
13(1)
Data integrity
14(3)
Calling a Stored Procedure
17(1)
Rules for Stored Procedures
17(2)
Modifying Stored Procedures
19(1)
Parameter Usage
20(1)
Flow control
21(6)
Code Blocks/Begin...End
21(1)
Decisions
22(1)
If...Else
22(1)
Case
23(2)
Goto label
25(1)
Loops
25(1)
The While Loop
25(1)
Pausing and Halting execution
26(1)
Nesting in Stored Procedures
27(1)
Returning Values
28(3)
Return
28(1)
Output
29(1)
Single Row of Data
30(1)
When an Error Occurs
30(1)
Other Issues with Returning Values
30(1)
Restoring the Example Databases to their Default Condition
31(1)
Summary
31(4)
Optimizing and Debugging
35(30)
Optimizing Stored Procedures
35(3)
Set Nocount On
35(2)
Recompile
37(1)
The Execution Plan
38(10)
Why Bother About the Execution Plan?
39(1)
Viewing the Execution Plan
39(1)
Graphical View of the Execution Plan
39(1)
Textual View of the Execution Plan
40(2)
The Execution Plan and Stored Procedures
42(1)
Multiple Statements within the Stored Procedure
43(1)
Understanding the Execution Plan
44(1)
Cost
44(3)
Benefits of Understanding Cost
47(1)
Common Mistakes
48(4)
Batches and GO
48(2)
Dynamic SQL in Procedures
50(1)
Security
51(1)
Error Handling
52(5)
@@Error
53(2)
Raiserror & Return Parameters
55(2)
SQL Server Debugger
57(5)
Finding the Debugger
57(1)
Using the Debugger
58(4)
Summary
62(3)
Concurrency, Cursors, and Transactions
65(46)
Cursors
66(15)
Syntax
66(1)
Special Cursor Syntax
67(3)
Alternate Cursor Syntax
70(1)
Accessing Cursors from Code
70(1)
Opening Cursors
70(1)
FETCH Statement
70(2)
@@Fetch_Status
72(1)
Closing Cursors
73(1)
Uses of Cursors
73(1)
Formatting a Result Set
73(5)
Batch Operations
78(2)
Best Practices
80(1)
Transactions
81(10)
Syntax
82(1)
Simple Transactions
82(4)
Savepoints
86(1)
Distributed Transactions
87(1)
Explicit versus Implicit Transactions
88(1)
Compiled SQL Server Code
88(2)
Best Practices
90(1)
Concurrency
91(18)
OS and Hardware Issues
92(1)
Concurrency Controls
92(1)
SQL Server
93(6)
Coding for Integrity and Concurrency
99(9)
Best Practices
108(1)
Summary
109(2)
Common Practices with Stored Procedures
111(24)
Typical Purposes
111(18)
Encapsulating Logic
112(3)
Improving Performance
115(5)
Easing Administration
120(1)
Performance Tuning
120(1)
Simplifying Code Deployment
120(1)
Improving Database Security
121(1)
Improving Data Validation
122(2)
Constraints
124(1)
Why not Build Validation in the Front-End Application?
125(1)
Triggers
126(1)
Executing Code at SQL Server Startup
127(2)
Points to Avoid While Using Stored Procedures
129(4)
Stored Procedure Grouping
129(2)
Nesting Stored Procedures
131(1)
Generic Stored Procedures
131(1)
Stored Procedures with Many Parameters
131(2)
Summary
133(2)
System Stored Procedures
135(44)
System Stored Procedures
136(15)
Effect of the 0x80000000 Status Bit
138(2)
Making System Stored Procedures with the 0x80000000 Bit
140(2)
An Important Feature of System Stored Procedures
142(2)
Other Features of SP_: Global Tables and Views
144(1)
Common Documented System Stored Procedures
145(4)
Other Important System Stored Procedures
149(1)
Mining System Stored Procedures
150(1)
Undocumented Functionality
151(15)
Finding Undocumented Extended Stored Procedure Functionality
152(1)
Windows-Registry Related Stored Procedures
152(1)
The Windows Registry
152(1)
XP_RegRead
153(2)
XP_RegWrite
155(1)
XP_RegEnumKeys
156(1)
XP_RegEnumValues
157(1)
XP_RegDeleteKey
157(1)
XP_RegDeleteValue
158(1)
XP_RegAddMultiString
158(1)
XP_RegRemoveMultiString
159(1)
XP_Instance_Reg extended stored procedures
160(1)
The File System
161(1)
XP_AvailableMedia
161(1)
XP_SubDirs
162(1)
XP_DirTree
162(1)
XP_FixedDrives
163(1)
XP_FileExists
163(1)
XP_ReadErrorLog
164(2)
Performing Complex Tasks with System Stored Procedures
166(2)
Tracing Object Creation and Deletion
168(1)
SQL Mail
169(7)
Best Practice Tips for SQL Mail
170(1)
XP_SendMail Recursion
170(2)
XP_SendMail Bullet-proofing
172(1)
Breaking the Exchange Umbilical Cord - XP_SMTP_SendMail
172(4)
Summary
176(3)
User Defined Functions
179(18)
UDFs
179(2)
In-Built Functions
180(1)
Creating a UDF
181(5)
Types of Functions:
181(1)
Deterministic Functions
182(1)
Non-Deterministic Functions
182(1)
Computed Columns
182(1)
Example of Creating a UDF
183(1)
Converting a Non-Deterministic Function to Deterministic
183(3)
Scalar Valued Functions
186(2)
Table Data Type
188(5)
Single Statement Table Function
188(2)
Multi-Statement Table Functions
190(1)
Table Variables
190(2)
In-built Functions with Table Data Type
192(1)
Schema Binding
193(1)
Stored Procedures versus UDFs
194(1)
Summary
195(2)
Triggers
197(22)
What is a Trigger?
198(2)
Why use Triggers?
200(1)
Performance
201(1)
Deferred Updates and Direct Updates
202(1)
Creating and using a trigger
202(4)
The Conceptual Tables within Triggers
204(1)
Triggers Fired on an Update
205(1)
Types of Trigger
206(5)
FOR
206(1)
After
206(2)
Ordering Trigger Actions
208(1)
Instead Of
209(1)
Cascading
210(1)
No Rows Updated
210(1)
Transactions and Triggers
211(1)
Trigger versus Constraints
212(1)
Triggers versus Stored Procedure
213(1)
Replication
213(2)
Recursion
215(1)
Good Practice
216(1)
Bad Practice
216(1)
Summary
217(2)
Security
219(28)
Increased Need for Security
219(1)
SQL Server Vulnerabilities
220(25)
Misconfiguration of SQL Servers
220(1)
SQL Server Setup
220(3)
Permission Paths
223(8)
Putting it all together
231(3)
SQL Injection Attacks
234(1)
The Problem
234(3)
The Solutions
237(2)
Encrypting Stored Procedures
239(1)
The syscomments Table
240(1)
Breaking Object Encryption in SQL 2000
241(1)
A Strategy For Encrypting Your Data
242(1)
SQL Buffer Overflow
243(1)
Installing a SSL Certificate for SQL Server
244(1)
Importing the certificate:
244(1)
Using the SetCert utility
245(1)
Summary
245(2)
Appendix A: Support, Errata, and forums.apress.com
247(4)
Customer Support
247(1)
Errata
247(1)
The Peer-to-Peer Forums at forums.apress.com
248(3)
Index 251


Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at Fat-Belly.com.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97814302112592e.html
Märksõnad: