Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The

Summary

In this chapter you were introduced to arrays in Transact-SQL. Although Transact-SQL itself doesn't offer support for arrays, we've built the next best thing using extended procedures and system functions. The end result is functionality that's relatively seamless, efficient, and fast. We were able to add this powerful functionality to Transact-SQL through our knowledge and familiarity with other languages and tools. The array model presented here brings together the strengths of multiple languages: It's based on functionality that originally appeared in Clipper, and it's written in C/C++ and Transact-SQL.