| Assembly | SqlServer.Rules.dll |
| Namespace | SqlServer.Rules.Design |
| Class | AvoidSelectIntoRule |
| Id | SRD0041 |
| Friendly Name | Avoid SELECT INTO temp or table variables |
| Category | Design |
| Ignorable | true |
| Applicable Types | Procedure |
| Scalar Function | |
| Table Valued Function |
Avoid use of the SELECT INTO syntax.
Avoid using SELECT INTO to create temp tables or table variables. Create these tables normally using a DECLARE or CREATE statement.