There will be another referendum
Even if it's a no vote, this has started a spark in Scotland. People will want independence sooner or later. Whatever happens from here on out, nothing will be the same. The English will always be wary that they wanted to be a separate country and if anything bad happens in Scotland, it'll be blamed on the no. Even Cornwall and Wales are in talks to have their own referendum. The UK's days are numbered. It's become antiquated and the Queen is losing ha antiquated grip. I don't blame the Scottish. Most of the focus from politicians in the UK is on London, let alone other parts of England/the north. Then there are parts of England that are secondary and tertiary BEFORE even introducing Wales/NI/Scotland to the fold. Divided countries mean smaller areas/more focused politicians to the issues that affect the country's people, which is a plus FOR THEM. Which is what democracy is about.
TL
R - Even if it's a no (which it might be), it's still starting the ball rolling