clear cached windows credentials
q: I selected “Save my credentials” when logging into a web site or server. How can I remove the credentials?
a: from command prompt run:
rundll32.exe keymgr.dll, KRShowKeyMgr
SQL Convert String to Date
MSSQL 2005
date input format YYYYMMDDHHMMSSNN
date ouput format YYYY-MM-DD HH:MM:SS
update tablename
set editDate = substring(editdate,1,4) + '-' + substring(editdate,5,2) + '-' + substring(editdate,7,2) + ' ' + substring(editdate,9,2) + ':' + substring(editdate,11,2) + ':' + substring(editdate,13,2)