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

Array System Functions

Once the extended procedures have been added to the server, the next thing we need to do is set up system functions to call them. This will make our arrays easier to use and more functional than would be possible with extended procedures only. You'll recall from Chapter 10 that system functions can be created through an undocumented process involving the system_function_schema pseudo-user. We'll create these array functions as system functions to make them available from any database without requiring a database prefix. Here's a script that creates them:

 USE master GO EXEC sp_configure 'allow updates',1 GO RECONFIGURE WITH OVERRIDE GO DROP FUNCTION system_function_schema.fn_createarray, system_function_schema.fn_setarray, ...