The Scots have saved themselves a lot of very major hassles by voting "No" on statehood, and even more hassles for Alex Salmond, who now gets to, sort of, retire. They really needed their own currency if they were going independent, and eighteen months would not have been enough time to get that organized. Also, they would have needed to negotiate a relationship with the EU, figure out their new relationship with not-so-Great Britain, etc., etc. Oh, yeah, and what about NATO?
Salmond is not entirely out of the picture, I suspect. Those last-minute, craven crumblings by Cameron still are likely to demand some negotiation, and I can't see Salmond just staying out of it. The Scottish Nationalist Party will need a bit of charismatic leadership, and Salmond fits the bill.