SSC-FDM-TS0030
SET ANSI_PADDING ON statement is commented out, which is equivalent in Snowflake.
Description
Snowflake always preserves trailing spaces in string values when they are inserted into columns. This behavior is equivalent to SET ANSI_PADDING ON
in SQL Server. Therefore, when SnowConvert encounters a SET ANSI_PADDING ON
statement, it adds this FDM and comments it out.
Code example
Input Code:
OUTPUT CODE
Recommendations
If you need more support, you can email us at snowconvert-support@snowflake.com
Last updated