راهنمای گورو برای رویه‌های ذخیره‌سازی SQL ServerTM، XML و HTML

The Microsoft Transact-SQL programming language has become an increasingly popular solution for developers seeking to build powerful and scalable distributed SQL Server applications. This follow-up to the widely acclaimed The Guru's Guide to Transact-SQL covers current subjects critical to successful SQL Server application development in depth, while leading developers to new heights in their overall programming skills. Blending theoretical detail with practical application, this comprehensive reference begins by providing a foundational overview of SQL Server stored procedure programming. From there, the book moves on to best practices and design considerations before progressing to advanced topics -- providing the most complete coverage of SQL Server stored procedure programming available in one source. Topics such as extended procedures, OLE Automation, database design, and XML are covered in detail, while the book spotlights undocumented language features and brings the first application of design patterns to SQL. The preview of.NET and a groundbreaking way to add arrays to Transact-SQL make for the most thorough and engaging read published to date on SQL Server programming. The Guru's Guide to SQL Server Stored Procedures, XML, and HTML includes sample projects with complete source code suitable for plugging into real world applications. Additional highlights include: End-to-end coverage of stored procedure construction, best practices, and common conventions. In-depth coverage of "procedural" objects, including triggers, views, and user-defined functions. A comprehensive discussion of employing HTML and XML in SQL Server applications, as well as an introduction to Microsoft's new .NET platform. Expert advice on debugging and profiling stored procedure code. Step-by-step instructions on how to create advanced stored procedure objects including extended stored procedures and administrative procedures. A behind-the-scenes look at undocumented Transact-SQL elements and coding tricks. Software engineering essays addressing the work environment, evolutionary code development, and software testing. An accompanying CD-ROM contains the book's source code along with several handy database administration tools. More than 600 code files, programming utilities, extended procedures, and SQL scripts demonstrate the real power of SQL Server programming and provide a tremendous value to the reader. Both comprehensive and practical, The Guru's Guide to SQL Server Stored Procedures, XML, and HTML provides developers with a complete tool set for becoming expert stored procedure programmers and better software practitioners. SQL Server developers worldwide raved about Ken Henderson's The Guru's Guide to Transact-SQL : its exceptionally clear, conversational explanations, and its powerfully useful projects and code examples. This book helps SQL Server developers take the next step -- building more powerful, robust applications than ever before. Henderson identifies several key areas of SQL Server development that offer the greatest power -- and then covers each of them in exceptional detail. The book includes especially thorough coverage of Transact-SQL stored procedure programming, including features such as extended procedures, database design, and XML that are often disregarded in competitive books. Henderson introduces a method he has developed to add arrays to T-SQL, something previously thought impossible. He offers an ideal balance of theory and code, gradually building on basic techniques to create increasingly sophisticated solutions, and teaching the philosophy of Transact-SQL programming alongside syntax and technique. An accompanying CD-ROM includes extensive source code, including valuable proprietary code that makes T-SQL queries run faster. For every SQL Server developer. Working from the assumption that the human brain learns by associating new data with what it already knows, we'll spend this chapter building a base framework onto which we can assemble the knowledge conveyed by the remainder of the book. Explores the foundations of SQL and Transact-SQL programming to teach readers how to develop coding techniques and discover solutions to programming problems, then covers practices, design considerations, and advanced topics.