SA0125 : Avoid use of the SELECT INTO syntax | ![]() |
The topic describes the SA0125 analysis rule.
Avoid use of the SELECT INTO syntax
The rule checks for SELECT INTO statement being used.
Consider replacing the SELECT INTO statement with explicit table creation and then use the INSERT INTO statement.
The rule has a Batch scope and is applied only on the SQL script.
Name | Description | Default Value |
---|---|---|
RuleSuppressMark | Suppress rule reporting a rule violation in case a comment containing the value of this parameter is found close to the source of violation. | IGNORE:SA0125 |
The rule does not need Analysis Context or SQL Connection.
Design Rules
1SELECT * INTO Table2 FROM Table1 2 3SELECT * INTO Table2 /*IGNORE:SA0125*/ FROM Table1 4 5SELECT * INTO /*IGNORE:SA0125*/ Table2 FROM Table1
Message | Line | Column | |
---|---|---|---|
1 | SA0125 : Avoid use of the SELECT INTO syntax. | 1 | 9 |
© Ubitsoft Ltd. All Rights Reserved.