Visual studio version list

Here by a list of the version numbers used by Visual Studio.

Product	Code name	Version name	Version number	Release date
Visual Basic 1.0
Visual Basic		Original version (RTM)	1.0	05/1991
Visual Basic 2.0
Visual Basic 2		Original version (RTM)	2.0	11/1992
Visual Basic 3.0
Visual Basic 3		Original version (RTM)	3.0	summer 1993
Visual Basic 4
Visual Basic 4		Original version (RTM)	4.0	08/1995
Visual Studio 97
Visual Studio 97	Boston	Original version (RTM)	5.0	02/1997
Visual Studio 6.0
Visual Studio 6.0	Aspen	Original version (RTM)	6.0	06/1998
Visual Studio .NET
Visual Studio .NET	Rainier	Original version (RTM)	7.0	13/02/2002
Visual Studio .NET 2003
Visual Studio .NET 2003	Everett	Original version (RTM)	7.1	24/04/2003
Visual Studio .NET 2005
Visual Studio .NET 2005	Whidbey	Beta 1	8.0.40607.16
Visual Studio .NET 2005	Whidbey	Beta 2	8.0.40607.16
Visual Studio .NET 2005	Whidbey	Release Candidate	8.0.50727.26
Visual Studio .NET 2005	Whidbey	Original version (RTM)	8.0.50727.42	7/11/2005
Visual Studio .NET 2005	Whidbey	Service pack 1	8.0.50727.867
Visual Studio .NET 2008
Visual Studio v2008	Orcas	Beta 1	9.0.20404.00
Visual Studio .NET 2008	Orcas	Beta 2	9.0.20706.01
Visual Studio .NET 2008	Orcas	Original version (RTM)	9.0.21022.08	19/11/2007
Visual Studio .NET 2008	Orcas	Service pack	9.0.30729.1 SP
Visual Studio .NET 2010
Visual Studio .NET 2010 Ctp	Dev10/Rosario	CTP	10.0.11001.01
Visual Studio 2010 beta	Dev10/Rosario	Beta 1	10.0.20506.01
Visual Studio 2010	Dev10/Rosario	Original version (RTM)	10.0.30319.1 RTM
Visual Studio 2010	Dev10/Rosario	Service pack 1	10.0.40219.1 SP1Rel

How is the version number created:

The Visual Studio 2010 version number is 10.0.30319.1. The format Visual Studio build numbers is YMMDD.NN.

Where:

• Y: This increases every year the team is working on the product


• MM: The month in which the build was compiled


• DD: The day on which the build was compiled


• NN: Number of recompiles of the build (during the development this number is mostly 00 or 01, but when a build gets branched for release, the other parts of the build number are freezed and only this part increments)

This build number format is not only used for Visual Studio and .NET, but also for many other products like Commerce Server 2009 or Microsoft Silverlight.

*Orginally the Y was the last character of the calendar year, but with the beginning of the development of Visual Studio 2008 it has been changed to the number of the years the team is working on the project.

IIS Feature Requirement Warning Message during SQL Server 2005 Setup on Windows server 2008.

First time I'm installing reporting service + sql on a windows 2008 server and already having some trouble. Here is the fist one.

If you receive a warning message for the IIS Feature Requirement item on the System Configuration Check page during the SQL Server 2005 installation on Windows Vista/Windows Server Longhorn, chances are you did not install all the IIS 7 role services that SQL Server depends on. Here is the list of IIS 7 role services that need to be installed:

• Static Content
• Default Document
• HTTP Redirection
• Directory Browsing
• ASP.Net
• ISAPI Extension
• ISAPI Filters
• Windows Authentication (Not available on Windows Vista Basic/Premium)
• IIS Metabase
• IIS 6 WMI

To add role services, open Server Manager, click on Go To Manage Role under the Role Summary tab, click on Add Role Serives under the Web Server (IIS) tab.

SQL: Getting Only the Date Part of a Date/Time Stamp in SQL Server

Using SQL 2005
methode 1:

CAST((
STR( YEAR( GETDATE() ) ) + '/' +
STR( MONTH( GETDATE() ) ) + '/' +
STR( DAY( GETDATE() ) ))
AS DATETIME)

methode 2(I think the beter one):

CAST(
FLOOR( CAST( GETDATE() AS FLOAT ) )
AS DATETIME)