T-SQL Analyzer

# SQL Server Rule: SRD0015 | | | |----|----| | Assembly | SqlServer.Rules | | Namespace | SqlServer.Rules.Design | | Class | UseColumnListWithInsertsRule | ## Rule Information | | | |----|----| | Id | SRD0015 | | Friendly Name | Implicit column list | | Category | Design | | Ignorable | false | | Applicable Types | Procedure | ## Description Always use a column list in INSERT statements. ## Summary Always use a column list in INSERT statements. ### Examples ```sql CREATE PROCEDURE dbo.ExecInto AS set nocount on DECLARE @SQL NVARCHAR(2048) INSERT INTO dbo.TestTableSSDT EXEC (@sql) -- SML021, SRD0015, SRD0024 ``` ### Remarks When inserting into a table or view it is recommended that the target column list be explicitly specified. This results in more maintainable code and helps in avoiding problems when the table structure changes (like adding or dropping a column). _{^{Generated by a tool}}