Chapter 23. Arrays

If you would master the craft of programming do this: never stop learning. Never be satisfied with what you know, always purpose to improve and add to it somehow, in some way. Craft first your mind, then spend the rest of your life letting it craft you.

H. W. Kenton

My previous book, The Guru's Guide to Transact-SQL, included a chapter on array processing in Transact-SQL that presented a number of ways of working around the fact that Transact-SQL doesn't have built-in array support. These techniques originated from two methods of approximating array support in the language: using tables (with columns simulating array dimensions) and using long varchar columns (with an entire dimension stored in a single column). Although ...

Get Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.