sql-server - SQL Server ANSI_Padding

Question

如果我右键单击 SQL Server Management Studio 中的表并选择“将表脚本编写为 > 创建到 > 新查询编辑器窗口”，则显示的代码包含:

设置 ANSI_PADDING 为开

...创建表...

设置 ANSI_PADDING 关闭

所以，我猜测，ANSI_Padding打开还是关闭都会影响整个数据库，打开建表然后又关闭？

如果您创建一个关闭 ANSI_Padding 的表会发生什么情况？如何为该表打开它？

Answer 1

SET ANSI_PADDING Controls the way the column stores values shorter than the defined size of the column, and the way the column stores values that have trailing blanks in char, varchar, binary, and varbinary data.

In a future version of MicrosoftSQL Server ANSI_PADDING will always be ON and any applications that explicitly set the option to OFF will produce an error. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

此设置仅影响新列的定义。创建列后，SQL Server 根据创建列时的设置存储值。 现有列不会受到此设置的后续更改的影响。