sql2008和2012区别_SQL 2008和2012之间的区别

Dear Friends,

Good Morning,

Can any one please tell about the difference between SQL Server 2008 and 2012.

Regards

Arul. R

解决方案1 Maximum number of concurrent connections:

The Maximum number of concurrent connections to SQL Server 2008 is 32767.

Maximum number of concurrent connections:

SQL server 2012 has unlimited concurrent connections.

2Precision used for spatial calculations:

The SQL Server 2008 uses 27 bit bit precision for spatial calculations.Precision used for spatial calculations:

The SQL Server 2012 uses 48 bit precision for spatial calculations

3TRY_CONVERT() and FORMAT() functions:

TRY_CONVERT() and FORMAT() functions are not available in SQL Server 2008TRY_CONVERT() and FORMAT() functions:

TRY_CONVERT() and FORMAT() functions are newly included in SQL Server 2012

4

ORDER BY Clause with OFFSET / FETCH options:

ORDER BY Clause does not have OFFSET / FETCH options as in SQL Server 2012

ORDER BY Clause with OFFSET / FETCH options:

ORDER BY Clause now have OFFSET / FETCH options to use paging to show required rows per page in applications and allow the user to scroll through each page of results rather than download the entire set

In the sample query below, SQL Server would return 10 records beginning with record 11. The OFFSET command provides a starting point for the SELECT statement in terms of paging, and the FETCH command provides how many records to return at a time.

SELECT BusinessEntityID, FirstName, LastName

FROM Person.Person

ORDER BY BusinessEntityID

OFFSET 10 ROWS

FETCH NEXT 10 ROWS ONLY;