SSP-1899 Add rest of reference tests part 1 of 2

This adds all the ssp api reference test suites except for 9 which need more testing on mssql. They will be committed in the future and noted as part 2 of 2.