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;