SQL 2008和2012之间的区别 [英] Difference Between SQL 2008 and 2012

问题描述

亲爱的朋友们，



早上好，



任何人都可以告诉我们之间的区别SQL Server 2008和2012.







问候



Arul。 R

Dear Friends,

Good Morning,

Can any one please tell about the difference between SQL Server 2008 and 2012.



Regards

Arul. R

推荐答案

您是否尝试 search / look on网络 [ ^ ]？br />


几个链接：

MSDN：SQL Server 2012中的新功能 [ ^ ]

sql server 2008和sql server 2012有什么区别 [ ^ ]

Did you try to search/look on web[^]?

Couple of links:
MSDN: What's New in SQL Server 2012[^]
what is difference between sql server 2008 and sql server 2012 [^]

1最大数量并发连接：

SQL Server 2008的最大并发连接数为32767.

最大并发连接数：

SQL server 2012具有无限的并发连接。

2用于空间计算的精度：

SQL Server 2008使用27位精度进行空间计算。用于空间计算的精度：

SQL Server 2012使用48位精度进行空间计算

3 TRY_CONVERT（）和FORMAT（）函数：

SQL Server 2008中没有TRY_CONVERT（）和FORMAT（）函数TRY_CONVERT（）和FORMAT（）函数：

SQL Server 2012中新包含了TRY_CONVERT（）和FORMAT（）函数/>
4

带OFFSET / FETCH选项的ORDER BY子句：

ORDER BY子句没有像SQL Server 2012中那样的OFFSET / FETCH选项

ORDER BY子句与OFFSET / FETCH选项：

ORDER BY子句现在有OFFSET / FETCH选项使用分页来显示应用程序中每页所需的行并允许用户滚动每个结果页面而不是下载整个集合



在下面的示例查询中，SQL Server将返回以记录11开头的10条记录.OFFSET命令提供了一个起点te中的SELECT语句rms的分页和FETCH命令提供一次返回的记录数。



SELECT BusinessEntityID，FirstName，LastName

FROM Person .Person

订购BusinessEntityID

OFFSET 10行

FETCH NEXT 10行;

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.
2 Precision 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
3 TRY_CONVERT() and FORMAT() functions:
TRY_CONVERT() and FORMAT() functions are not available in SQL Server 2008 TRY_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;

It可以帮到你



SQL Server 2008和SQL Server 2012之间的区别 [ ^ ]

It can help you

Difference between SQL Server 2008 and SQL Server 2012 [^]

这篇关于SQL 2008和2012之间的区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！