N a g a s a i
Software Engineer, Blogger, Gadgets, Sports, Circket, Movies and Gamer.
Wednesday, May 20, 2009
Date Formats in SQL Server
›
---Yesterday select dateadd(d,-1,getdate()) as yesterday --First Day of Current Week select dateadd(wk,datediff(wk,0,getdate()),0) as [Firs...
Tuesday, March 31, 2009
Limiting the File Upload Size in ASP.NET
›
By default, the maximum size of a file to be uploaded to a server using the ASP.NET FileUpload control is 4MB. You cannot upload anything ...
Friday, March 27, 2009
IPL Season II Schedule
›
Sports
Saturday, February 28, 2009
How Get Start and End days of a week/month?
›
DECLARE @SchDate datetime SET @SchDate = getdate() -- Gets Week Start Day SELECT DATEADD(wk, DATEDIFF(wk, 6, @SchDate), 6) AS WeekSt...
Friday, February 27, 2009
TSQL List of table and size in SQL database
›
I found this on searching for list of tables. SELECT X.[name], REPLACE(CONVERT(varchar, CONVERT(money, X.[rows]), 1), '.00'...
‹
›
Home
View web version
