Hey guys, i know that MySQL can support fields which are auto-incremental...they increase the value by 1 for each new record automatically.
Is this true for MS SQL?
And pls tell me how different are the date formats for MySQL and MS SQL?
MS SQL can do auto-increment, and you specified the incremental seed (example +1) but you could have the increment as +5 if you want. not sure all the rules with the date data types... best to look into the help. p.s. MS SQL <7 is rubbish, 7+ is pretty good.
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20386357.html