Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par Mahmoud AbdelBadei , IT Department Official , Shoaa Alkhobar
Date de publication: 2014/05/07
Samer Haterm
par Samer Haterm , Development Analyst , SyrianSoft, Damuscus.Ne

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.

Sandhya Binoy
par Sandhya Binoy , Software Professional , Karrox technologies

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.

 

 

karim kamel
par karim kamel , Developer Support Engineer , Microsoft

SQL Server2008

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

 

Sql Server2012

 

In Addition with SQL server2008, Web Development and Business Intelligence Enhanced with business intelligence features and Excel PowerPivot by adding more drill and KPI’s.

 

 

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?