Defalut Date syntax for MicroSoft SQL Server

Do you know the default syntax? ex. yyyy-mm-dd or mm/dd/yy???

With databases, I’d always use yyyy-MM-dd hh:mm:ss - it is pretty much universally accepted, because it is unambigous.

See www.sqlzoo.net, they have a wonderful reference as to the different quirks between all of the different database vendors.