What is the main differences between sql server 2008 and sql server 2012?

There is money put I've seen the most value New Analytic Functions like FIRST_VALUE LAST_VALUE

add ORDER BY in the OVER for aggregate functios Like SUM AVG

CONCATE,FORMAT and PARSE where added in sqlserver2012 which were not present in sqlserver2008.

1)Sequence is not avaiable in SQL server2008.Sequence is included in SQL Server2012.

Sequence is a user defined object that generates sequence of the number.

2)The maximum number of concurrent connections to SQL Server2008 is32767.

SQL Server2012 has unlimited number of concurrent connections.

3)SQL Server2008 uses27bit precision for calculations.

Sql server2012 uses48 bit precision for calculations.

4)TRY_CONVERT() and FORMAT() functions are included in SQL server2012

But not available in SQL server2008.

SQL Server2008

Web Development and Business Intelligence Enhanced with business intelligence features. Excel PowerPivot by adding more drill and KPI through.

Sql Server2012

http://wikidba.wordpress.com/2012/12/19/differences-between-sql-server-2008-and-2012/