SQL Server – How to get First and Last day of current and previous month without time

Get first day of current month
SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, CURRENT_TIMESTAMP), 0) AS FirstDayOfCurrentMonth

Get last day of current month
SELECT DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) +1, -1) AS LastDayOfCurrentMonth

Get first day of previous month
SELECT DATEADD(month, DATEDIFF(month, 0, GETDATE())-1,

Microsoft Visual Studio 2010 – How to add recaptcha and have it work with Microsoft’s CreateUserWizard

Let’s say you create a web site, and you want to add recaptcha to the aspx page where clients can sign up for an account. Instead of a custom sign up form, you instead use Microsoft’s CreateUserWizard control. I’ll explain …

Microsoft Visual Studio 2010 – How to Set Up Forms Authentication for Your ASP.NET Web Site

After developing a web site that uses Forms Authentication, you need to create a SQL database that stores the client’s log-in information along with any profiles. The tool that creates the tables in your database that is needed for your …

Microsoft Visual Studio 2010 – How to pre-compile your “Web Site” and FTP only portions of your site to your Host.

You decided to build a “Web Site” and not a “Web Solution”. You proceed to use the PUBLISH utility in Visual Studio and publish your entire site to your host. You later make a change to your Web Site and …