ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Mahmoud AbdelBadei , IT Department Official , Shoaa Alkhobar
تاريخ النشر: 2014/05/07
Samer Haterm
من قبل 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
من قبل 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
من قبل 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.

 

 

المزيد من الأسئلة المماثلة