Thursday 7 February 2013

SQL : Get Date Only

SQL
DATEADD(dd,0, DATEDIFF(dd, 0, GETDATE()))

SQL 2008
CAST(GETDATE() AS DATE)

Friday 1 February 2013

IIS 7 Blank Image Problem


Fisrttime when using IIS 7 in Windows 2008 Server i got problem. I can not display all image. After googling I get the solution. The problem is static content not checked yet.