The hotel posting method depends on the hotel. For some, as you said, you just give your Skymiles number at checkin. For others (Best Western for example) you have to sign up for their loyalty program and set up your profile with your Skymiles number.