Skip to main content

Posts

Showing posts with the label sql server 2016 vs SQL Server 2012 and 2014

difference between SQL Server 2012 and SQL Server 2016

In short, this article about differences - SQL Server 2012 and SQL Server 2016 and the detail as given below . About SQL Server 2012 as given below. Top 6 Features Coming to  SQL Server 2012 1.       In SQL Server 2012, uses  48 bit  precision for spatial. 2.       In SQL server 2012, has  unlimited concurrent connections  are available. 3.       In SQL server 2012, by default  supports 15,000  partitions in DB. 4.       In  SQL server 2012 , available new string function  CONCAT  to strings. 5.       In SQL server 2012, available new string function  FORMAT  to strings. 6.       In SQL server 2012, available new conversion functions are  PARSE, TRY_CONVERT , and  TRY_PARSE. About SQL Server 2016 as given below. Top 7 Features Comi...