SQL Server Development Q&A 200 Questions

Author: Zheng Jianfeng Dong Guoping (Editor)
Publisher:
Publish Date: 2005-09-01
Features: Includes all source code for this book, plus a valuable gift of a VB+SQL Server Enterprise Human Resource Management System and an ASP.NET+SQL Server Office Automation System. This book selects more than 260 highly practical problems and common techniques, aiming to help readers solve numerous practical issues frequently encountered in SQL Server database maintenance and management, as well as database application development, thereby improving their database maintenance and management skills and application development efficiency. The content of this book nearly covers all aspects of SQL Server database knowledge points, with main topics including installation and option settings, database configuration and option management, security management, optimizing server performance, database design and creation, tables, indexes, and views, stored procedures, triggers, transactions, cursors, distributed queries, full-text indexes and full-text search, Transact-SQL language basics, data import and export, database backup and restoration, and accessing SQL Server in Visual Basic, Visual C/C++, ASP, and ASP.NET environments. The problems listed in this book are all typical issues summarized from actual development projects after thorough research, and the solutions provided are highly practical. This book is suitable for readers who have a preliminary grasp of SQL Server database maintenance and management, as well as database application development, and can help them quickly master development techniques in practical applications.