T-SQL Analyzer

# SQL Server Rule: SRD0041 | | | |----|----| | Assembly | SqlServer.Rules | | Namespace | SqlServer.Rules.Design | | Class | AvoidSelectIntoRule | ## Rule Information | | | |----|----| | Id | SRD0041 | | Friendly Name | Avoid SELECT INTO temp or table variables | | Category | Design | | Ignorable | true | | Applicable Types | Procedure | | | Scalar Function | | | Table Valued Function | ## Description Avoid use of the SELECT INTO syntax. ## Summary Avoid using SELECT INTO to create temp tables or table variables. Create these tables normally using a DECLARE or CREATE statement. _{^{Generated by a tool}}