sqlmunkee (4/24/2012)
So, the key bit here is that SQL will *decide* whether the sequence is ascending or descending based on the INCREMENT BY argument. That's a bit misleading if your just starting out with sequences and SQL 2012 (like me) 🙂 Good question !
I agree that it seems misleading or confusing. That's why I always code the details even if they are the defaults and not required. That way, there is no question when someone else reads the code. It gets a little wordy but it alleviates confusion.
It's good to learn the new stuff. 🙂