Three attachments are provided:
- SQL scripts to create the Chinook database. These are provided with a small command file. The database is provided in two formats, one with auto incrementing primary keys and one without.
- A script to add a Stored Procedure.
- A sample DataSlave Map that calls the above Stored Procedure.
The Map assumes Windows integrated security to a local SQLEXPRESS database. This can be adjusted if necessary. The Map illustrates how to call the Stored Procedure with a hard coded search parameter and also using Map and Transform .NET Scripts to pass a parameter.
Thanks to Luis for the Chinook database.