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:
SET ANSI_PADDING ON;
OUTPUT CODE
----** SSC-FDM-TS0030 - SET ANSI_PADDING ON STATEMENT IS COMMENTED OUT, WHICH IS EQUIVALENT IN SNOWFLAKE. **
--SET ANSI_PADDING ON
Recommendations
If you need more support, you can email us at [email protected]
Last updated