От: | Olaf | ||
Дата: | 20.12.16 06:03 | ||
Оценка: | 71 (4) |
P.S.: Для тех кому интересно каким образом Microsoft смог обеспечить поддержку SQL Server на платформе Linux опубликована вводная статья SQL Server on Linux: How? Introduction...
SQL Server Database Engine
Memory-optimized tables and indexes now support computed columns.
...
Natively compiled modules now support the CROSS APPLY operator, and all JSON functions.
New string functions CONCAT_WS, TRANSLATE, and TRIM are added.
The WITHIN GROUP clause is now supported for the STRING_AGG function.
Two new Japanese collation families (Japanese_Bushu_Kakusu_140 and Japanese_XJIS_140) were added, and the collation option Variation-selector-sensitive (_VSS) was added for use in Japanese collations. For more detail see Collation and Unicode Support
New bulk access options (BULK INSERT and OPENROWSET(BULK...) enable access data directly from a file specified as CSV format, and from files stored in Azure Blog storage through the new BLOB_STORAGE option of EXTERNAL DATA SOURCE.