SQL Troubleshooting and Debugging Techniques

Author: Kang Bo
Publisher:
Publish Date: 2002-04-01
Features: SQL statements are essentially declarative languages, so it is difficult to eliminate their faults. Because it lacks an interactive debugger and cannot use developed error objects to generate error information, it is even unable to accurately determine which line of code caused the error. Therefore, we must exercise our initiative to establish an environment for troubleshooting SQL faults. This book primarily introduces all the knowledge required to effectively troubleshoot SQL query statement faults, explains how to establish a highly effective SQL environment, and provides the best programming skill practice. The book also guides readers to use common query types and offers specific content for debugging queries. This book is suitable for all readers who are familiar with SQL knowledge and wish to learn how to debug SQL statements.