Difference between SQL Server 2008 and SQL Server 2012
SQL SERVER 2008
1) TRY_CONVERT and FORMAT string functions are not available
2)The maximum number of concurrent connection to SQL Server 2008 is 32767.
3)SQL Server 2008 use 27 bit precision for Spatial calculation
4)ORDER BY clause does not have FETCH/OFFSET
5)SQL Server 2008 code name is Katmai.
6)SEQUENCE is not available in SQL Server 2008
7)The Full-Text search is not allow to search and index data stored in extended properties or metadata.
SQL SERVER 2012
1)TRY_CONVERT and FORMAT string functions are available
2)The maximum number of concurrent connection to SQL Server 2012 is unlimited
3)SQL Server 2012 use 48 bit precision for Spatial calculation
4)ORDER BY clause does have FETCH/OFFSET options to use paging to show required rows per page in application
5)SQL Server 2012 code name is Denali
6)SEQUENCE is available in SQL Server 2012 which is user define object type to generate sequence number.
7)The Full-Text search is allow to search and index data stored in extended properties or metadata.
SQL SERVER 2008
1) TRY_CONVERT and FORMAT string functions are not available
2)The maximum number of concurrent connection to SQL Server 2008 is 32767.
3)SQL Server 2008 use 27 bit precision for Spatial calculation
4)ORDER BY clause does not have FETCH/OFFSET
5)SQL Server 2008 code name is Katmai.
6)SEQUENCE is not available in SQL Server 2008
7)The Full-Text search is not allow to search and index data stored in extended properties or metadata.
SQL SERVER 2012
1)TRY_CONVERT and FORMAT string functions are available
2)The maximum number of concurrent connection to SQL Server 2012 is unlimited
3)SQL Server 2012 use 48 bit precision for Spatial calculation
4)ORDER BY clause does have FETCH/OFFSET options to use paging to show required rows per page in application
5)SQL Server 2012 code name is Denali
6)SEQUENCE is available in SQL Server 2012 which is user define object type to generate sequence number.
7)The Full-Text search is allow to search and index data stored in extended properties or metadata.
