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:

IN -> SqlServer_01.sql
SET ANSI_PADDING ON;

OUTPUT CODE

OUT -> SqlServer_01.sql
----** SSC-FDM-TS0030 - SET ANSI_PADDING ON STATEMENT IS COMMENTED OUT, WHICH IS EQUIVALENT IN SNOWFLAKE. **
--SET ANSI_PADDING ON

Recommendations

Last updated