SID dynaimcally generated

I am trying to find out if SID can be dynamically generated with a member
database, whereby shopper's get a unique SID for clicking my
affiliate links on my site, is there a tutorial of this being implemented?