Also, I am looking for a good site that has example programs to run on the basic stamp II.
First of all, read the book because it's got lots of cool stuff in it and it is written very well. Then Parallax.com ! They've got tons of downloadable pdfs of all their stamps in class educational books.
Here are all the Stamps in Class books, freely downloadable. And you can also download pdfs of all the articles about basic stamps on nuts and volts magazine, at the archive
here.
Anyways, to make tones with the piezospeaker, all you have to do is use simple FREQOUTs with the appropriate frequencies.
You could declare some constants first, for the frequencies of the notes you use (you can find note frequencies tables easily on the web), like:
A CON 880
B CON 988
C CON 1047
etc.
then you could either just write your FREQOUT statements one after the other, or you could store a sequence of notes in EEPROM with the DATA command (more on that is in the BOE bot book), then play the sequence with a FOR loop with a single FREQOUT command inside the loop.
But I'm sure there are some articles about this on the internet. Try to search it on the parallax forums too.