Book description
Writing Stored Procedures for Microsoft SQL Server focuses on teaching you not only how to build effective stored procedures, but also how to optimize and streamline them for long term use. Get an understanding of how SQL Server interprets stored procedures verses direct access via SQL queries. This is followed by detailed instructions on creating and maintaining a repository of stored procedures. Once you know how stored procedures are created and built, you are taught how to determine which logic within an application makes sense to be put into this scheme. Additionally, you're provided with guidance on making stored procedures that are portable across applications.
Table of contents
- Copyright
- About the Author
- Acknowledgments
- Introduction
- Introduction to Developing Stored Procedures
- Simple Stored Procedures
- Security and Advanced Procedure Development
-
XML and Triggers
-
SQL Server XML Support
- What Is XML?
- XML and HTML
- Microsoft and XML
- XML Fundamentals
- Using XML with SQL Server and Internet Information Server's Server Extensions
- SQL XML
- The FOR XML Clause
- Formatting Data with XSL
- XML and Style Sheets
- Putting It All Together
- Update Grams
- Setting Basic Security
- Security Configuration for URL Access
- Conclusion
- Writing Triggers
- Considerations When Using Stored Procedures and Triggers
-
SQL Server XML Support
- Index
Product information
- Title: Writing Stored Procedures for Microsoft SQL Server
- Author(s):
- Release date: June 2000
- Publisher(s): Sams
- ISBN: 0672318865
You might also like
book
SQL Server T-SQL Recipes, Fourth Edition
SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the …
book
Beginning SQL Server for Developers, Fourth Edition
Beginning SQL Server for Developers is the perfect book for developers new to SQL Server and …
book
Microsoft SQL Server 2014 Unleashed
The industry’s most complete, useful, and up-to-date guide to SQL Server 2014. You’ll find start-to-finish coverage …
book
Learn T-SQL Querying
Troubleshoot query performance issues, identify anti-patterns in code, and write efficient T-SQL queries Key Features Discover …