It is quite surprising to know the undocumented date and time related functions that work in both sql server 2000 and 2005 Run these and see(I think they are self-explanatory ) select {fn current_date()} select {fn current_time()} select {fn now()} select...