MS SQL Queries

exec sp_databases



SELECT DATEADD(hh, 9, '20030117')

hh = hours
s = seconds


reference

http://msdn.microsoft.com/en-us/library/ms186819.aspx