Compare dates in SQL server

Comparing dates in SQL server. This task took me lot of time. I was unable to get the syntax right. In the end my wife helped me out. Thanks to her.

CONVERT(VARCHAR(10), table.StartDate,120) <= CONVERT(varchar(10), GetDate(),120)

:)

Intellisense

Dynamic code generation has existed for quite a while. In fact, you'll find tools that can help developers generate tens of thousands of lines of code with just a click of a button. Some of these are even flexible enough to allow you to modify the tokens in the template—or even the templates themselves—for added control over the output of the code.

for complete article visit,
http://www.developer.com/net/net/article.php/3557701

Upload file from web form in ASP .net 2.0

Step 1. Use the ASp .net 2.0 File upload control

Step 2. In the code behind get the path of the folder where you want to upload the file

Step 3.
if (fupControl.HasFile)
{
string sFileName = fupControl.FileName;
sPath = sPath + "\\" + sFileName;
fupControl.SaveAs(sPath);
}

Step 4. You are done

its that simple

Visual Studio 2005 launched officially

At the official launch event in San Francisco Monday, Ballmer said the database, development tools and EAI platform -- combined with a common .NET programming model -- will enable customers and partners to connect applications, processes and systems together in unparalleled fashion.
Clad in suit and tie, Ballmer humbled himself before thousands of developers, acknowledging that the upgraded database -- the company's first release in five years -- was "a little bit long in the making."
SQL Server 2005 and Visual Studio 2005 are shipping as of Nov. 7 and will be widely available in the channel in December.
Microsoft also officially announced the Community Technology Preview of BizTalk 2006, formerly code-named Pathfinder, and said the final product will ship during the first half of 2006. The company plans to include 16 new application and technology adapters for Oracle's database and applications, Peoplesoft, Siebel, SAP, Tibco, JDEdwards, IBM DB2 in the base product at no additional cost.

Xbox 360 preview

Charles at his best

Everyday, for development activities, we leverage the power of Integrated Development Environments (IDE) such as Visual Studio, Eclipse, Borland Delphi et al. The power comes at a price. We tend to become habituated to the quirks and approaches of the IDE. The challenge, metaphorically put, is that we drive the IDE like a car and not become overly dependent on auto-pilot.
Charles Petzold – an authority on Windows Programming delivered a speech to the NYC .NET Developers’ group entitled "Does Visual Studio Rot the Mind". The speech expresses similar thoughts in a different style. It’s thoughtful (17 pages) – http://www.charlespetzold.com/etc/DoesVisualStudioRotTheMind.html. Do read it in your spare time regardless of whether you work on Microsoft technology, Java or Delphi.