skip to content
SQL Server 2000 stored procedures handbook Preview this item
ClosePreview this item
Checking...

SQL Server 2000 stored procedures handbook

Author: Tony Bain
Publisher: Berkeley, CA : Apress ; New York : Distributed to the Book trade in the United States by Springer-Verlag, ©2004.
Series: Expert's voice.
Edition/Format:   Print book : EnglishView all editions and formats
Summary:

* Shows you how to write more effective stored procedures and functions* Concise, detailed advice from SQL Server experts* Tackles issues barely covered in existing books, such as optimizing and  Read more...

Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Document Type: Book
All Authors / Contributors: Tony Bain
ISBN: 1590592875 9781590592878
OCLC Number: 53839434
Notes: Includes index.
Description: vii, 265 pages : illustrations ; 23 cm.
Contents: System Stored Procedure 6 --
User Stored Procedure 8 --
Creating Stored Procedures 9 --
Performance Consideration 11 --
Network Consideration 11 --
Why Use Stored Procedures? 11 --
Replication 12 --
Designing Good Stored Procedures 13 --
Data integrity 14 --
Calling a Stored Procedure 17 --
Rules for Stored Procedures 17 --
Modifying Stored Procedures 19 --
Parameter Usage 20 --
Flow control 21 --
Code Blocks/ BEGIN ... END 21 --
Decisions 22 --
Loops 25 --
Pausing and Halting execution 26 --
Nesting in Stored Procedures 27 --
Returning Values 28 --
Return 28 --
Output 29 --
Single Row of Data 30 --
When an Error Occurs 30 --
Other Issues with Returning Values 30 --
Restoring the Example Databases to their Default Condition 31 --
Chapter 2 Optimizing and Debugging 35 --
Optimizing Stored Procedures 35 --
Set Nocount on 35 --
Recompile 37 --
The Execution Plan 38 --
Why Bother About the Execution Plan? 39 --
Viewing the Execution Plan 39 --
The Execution Plan and Stored Procedures 42 --
Understanding the Execution Plan 44 --
Common Mistakes 48 --
Batches and GO 48 --
Dynamic SQL in Procedures 50 --
Security 51 --
Error Handling 52 --
@@Error 53 --
Raiserror & Return Parameters 55 --
SQL Server Debugger 57 --
Finding the Debugger 57 --
Using the Debugger 58 --
Chapter 3 Concurrency, Cursors, and Transactions 65 --
Syntax 66 --
Accessing Cursors from Code 70 --
Uses of Cursors 73 --
Syntax 82 --
OS and Hardware Issues 92 --
Concurrency Controls 92 --
Chapter 4 Common Practices with Stored Procedures 111 --
Typical Purposes 111 --
Encapsulating Logic 112 --
Improving Performance 115 --
Easing Administration 120 --
Simplifying Code Deployment 120 --
Improving Database Security 121 --
Improving Data Validation 122 --
Executing Code at SQL Server Startup 127 --
Points to Avoid While Using Stored Procedures 129 --
Stored Procedure Grouping 129 --
Nesting Stored Procedures 131 --
Generic Stored Procedures 131 --
Stored Procedures with Many Parameters 131 --
Chapter 5 System Stored Procedures 135 --
Effect of the Ox80000000 Status Bit 138 --
Other Features of SP_: Global Tables and Views 144 --
Common Documented System Stored Procedures 145 --
Other Important System Stored Procedures 149 --
Mining System Stored Procedures 150 --
Undocumented Functionality 151 --
Finding Undocumented Extended Stored Procedure Functionality 152 --
Windows-Registry Related Stored Procedures 152 --
The File System 161 --
Performing Complex Tasks with System Stored Procedures 166 --
Tracing Object Creation and Deletion 168 --
SQL Mail 169 --
XP_SendMail Recursion 170 --
XP_SendMail Bullet-proofing 172 --
Breaking the Exchange Umbilical Cord --
XP_SMTP_SendMail 172 --
Chapter 6 User Defined Functions 179 --
In-Built Functions 180 --
Creating a UDF 181 --
Types of Functions 181 --
Computed Columns 182 --
Example of Creating a UDF 183 --
Converting a Non-Deterministic Function to Deterministic 183 --
Scalar Valued Functions 186 --
Table Data Type 188 --
Single Statement Table Function 188 --
Multi-Statement Table Functions 190 --
Table Variables 190 --
In-built Functions with Table Data Type 192 --
Schema Binding 193 --
Stored Procedures versus UDFs 194 --
Chapter 7 Triggers 197 --
Why use Triggers? 200 --
Performance 201 --
Deferred Updates and Direct Updates 202 --
Creating and using a trigger 202 --
The Conceptual Tables within Triggers 204 --
Triggers Fired on an Update 205 --
Types of Trigger 206 --
For 206 --
After 206 --
Ordering Trigger Actions 208 --
Instead of 209 --
Cascading 210 --
No Rows Updated 210 --
Transactions and Triggers 211 --
Trigger versus Constraints 212 --
Triggers versus Stored Procedure 213 --
Replication 213 --
Recursion 215 --
Good Practice 216 --
Bad Practice 216 --
Chapter 8 Security 219 --
Increased Need for Security 219 --
SQL Server Vulnerabilities 220 --
Misconfiguration of SQL Servers 220 --
SQL Injection Attacks 234 --
Encrypting Stored Procedures 239 --
SQL Buffer Overflow 243 --
Installing a SSL Certificate for SQL Server 244 --
Customer Support 247.
Series Title: Expert's voice.
Responsibility: Tony Bain [and others].

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.

Similar Items

Related Subjects:(4)

User lists with this item (1)

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/53839434> # SQL Server 2000 stored procedures handbook
    a schema:Book, schema:CreativeWork ;
   library:oclcnum "53839434" ;
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/cau> ;
   library:placeOfPublication <http://dbpedia.org/resource/New_York_City> ; # New York
   library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/864041914#Place/berkeley_ca> ; # Berkeley, CA
   schema:about <http://experiment.worldcat.org/entity/work/data/864041914#CreativeWork/sql_server> ; # SQL server.
   schema:about <http://id.worldcat.org/fast/872390> ; # Computer programming
   schema:about <http://dewey.info/class/005.7585/e21/> ;
   schema:about <http://id.worldcat.org/fast/1376937> ; # SQL server.
   schema:about <http://id.worldcat.org/fast/1093575> ; # Relational databases
   schema:about <http://id.worldcat.org/fast/864205> ; # Client/server computing
   schema:bookFormat bgn:PrintBook ;
   schema:contributor <http://viaf.org/viaf/34132008> ; # Tony Bain
   schema:copyrightYear "2004" ;
   schema:datePublished "2003" ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/864041914> ;
   schema:inLanguage "en" ;
   schema:isPartOf <http://experiment.worldcat.org/entity/work/data/864041914#Series/expert_s_voice> ; # Expert's voice.
   schema:isPartOf <http://experiment.worldcat.org/entity/work/data/864041914#Series/the_expert_s_voice> ; # The expert's voice.
   schema:name "SQL Server 2000 stored procedures handbook"@en ;
   schema:productID "53839434" ;
   schema:publication <http://www.worldcat.org/title/-/oclc/53839434#PublicationEvent/berkeley_ca_apress_new_york_distributed_to_the_book_trade_in_the_united_states_by_springer_verlag_2004> ;
   schema:publisher <http://experiment.worldcat.org/entity/work/data/864041914#Agent/distributed_to_the_book_trade_in_the_united_states_by_springer_verlag> ; # Distributed to the Book trade in the United States by Springer-Verlag
   schema:publisher <http://experiment.worldcat.org/entity/work/data/864041914#Agent/apress> ; # Apress
   schema:workExample <http://worldcat.org/isbn/9781590592878> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/53839434> ;
    .


Related Entities

<http://dbpedia.org/resource/New_York_City> # New York
    a schema:Place ;
   schema:name "New York" ;
    .

<http://experiment.worldcat.org/entity/work/data/864041914#Agent/distributed_to_the_book_trade_in_the_united_states_by_springer_verlag> # Distributed to the Book trade in the United States by Springer-Verlag
    a bgn:Agent ;
   schema:name "Distributed to the Book trade in the United States by Springer-Verlag" ;
    .

<http://experiment.worldcat.org/entity/work/data/864041914#Series/expert_s_voice> # Expert's voice.
    a bgn:PublicationSeries ;
   schema:hasPart <http://www.worldcat.org/oclc/53839434> ; # SQL Server 2000 stored procedures handbook
   schema:name "Expert's voice." ;
    .

<http://experiment.worldcat.org/entity/work/data/864041914#Series/the_expert_s_voice> # The expert's voice.
    a bgn:PublicationSeries ;
   schema:hasPart <http://www.worldcat.org/oclc/53839434> ; # SQL Server 2000 stored procedures handbook
   schema:name "The expert's voice." ;
    .

<http://id.worldcat.org/fast/1093575> # Relational databases
    a schema:Intangible ;
   schema:name "Relational databases"@en ;
    .

<http://id.worldcat.org/fast/1376937> # SQL server.
    a schema:CreativeWork ;
   schema:name "SQL server." ;
    .

<http://id.worldcat.org/fast/864205> # Client/server computing
    a schema:Intangible ;
   schema:name "Client/server computing"@en ;
    .

<http://id.worldcat.org/fast/872390> # Computer programming
    a schema:Intangible ;
   schema:name "Computer programming"@en ;
    .

<http://viaf.org/viaf/34132008> # Tony Bain
    a schema:Person ;
   schema:familyName "Bain" ;
   schema:givenName "Tony" ;
   schema:name "Tony Bain" ;
    .

<http://worldcat.org/isbn/9781590592878>
    a schema:ProductModel ;
   schema:isbn "1590592875" ;
   schema:isbn "9781590592878" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.