Next step of programming

Identity fields are auto incremented field. There can be only one identity field per table. It needs the base value and the increment value with which it will be incremented whenever new record is inserted in the table. An IDENTITY column of tinyint datatype can go upto 255, smallint can go upto 32767, int can go upto 2147483647 and bigint can go upto 9223372036854775807.

CREATE TABLE dbo.Employee ( EmployeeID smallint identity(7,2), EmployeeName char(20) )

Now we need to just enter the name of the employee not his id.

Insert into table dbo.Employee(EmployeeName) Values(“Kshyup”)

After insertion and deletion of data we may be in need of resetting the identity column counter for that we can make use of DBCC CHECKIDENT. For example

DBCC CHECKIDENT(‘Employee’, RESEED, 1)

Five focus areas

1. Riding the next-generation platform wave
2. Inspiring developer delight
3. Powering breakthrough departmental applications
4. Enabling emerging trends such as cloud computing
5. And Democratizing application life-cycle management (ALM)

This includes new capabilities that make it easier for all contributors on the software team to participate throughout the life cycle — from the core developers and testers to the wider team of project managers, designers and business analysts. Highlights include the following:

1. Modeling tools
2. Improved efficiency throughout the test cycle
3. Substantial improvements in collaboration capabilities

For more visit
http://msdn.microsoft.com/en-us/vstudio/products/cc948977.aspx
http://www.microsoft.com/presspass/press/2008/sep08/09-29VS10PR.mspx

Visual Studio 2010