marlon.seton (5/1/2012)
I think this question indicates that using default values with a new item like CREATE SEQUENCE isn't a great idea. I, for one, will be defining everything (AS, START WITH, INCREMENT BY, MINVALUE, MAXVALUE, CYCLE, CACHE) if I get round to using sequences in SQLServer. I know it might look wordy and take up a few more lines but for the sake of clarity, and potential help in solving problems, I would think it worth it.
Defaults aren't bad... a default sequence is a bigint starting at -9,223,372,036,854,775,808 and counting up.
In this case the qotd started at the bottom end of the int and counted down.