Schema

Assume a database was created using the following script on a server that has all the installation defaults, namely character set “iso_1” and default sort order ID 50, “binary_iso_1”.

> create database xpubs
> go
> use xpubs
> go
> create table authors (au_id int, au_lname varchar(255), au_fname varchar(255))
> go
> create index au_idx on authors(au_lname, au_fname)
> go

Then the data was loaded into the server using a series of inserts and updates.