If they vote No to independence, I don't see another referendum for a long time. However I do think the Scottish Parliament will be granted more powers to dictate their own national policies since while all votes haven't been counted, they do appear to be very close currently with at least 6 regions still needing to be counted in full.