# SQL Server Rule: SML012
| | |
|----|----|
| Assembly | TSQLSmellSCA |
| Namespace | TSQLSmellSCA |
| Class | TSQLSmellSCA12 |
## Rule Information
| | |
|----|----|
| Id | SML012 |
| Friendly Name | Missing Column specifications on insert |
| Category | CodeSmells |
| Ignorable | false |
| Applicable Types | Model |
## Description
Missing Column specifications on insert
### Examples
```sql
CREATE PROCEDURE dbo.InsertMissingColumnSpecifiers
AS
SET NOCOUNT ON;
INSERT INTO dbo.TestTableSSDT
SELECT [IdCol],Col1,Col2,Col3,DateCol FROM dbo.TestTableSSDT;
INSERT INTO dbo.TestTableSSDT([IdCol],Col1,Col2,Col3,DateCol)
SELECT [IdCol],Col1,Col2,Col3,DateCol FROM dbo.TestTableSSDT;
-- SML012, SRD0009, SRD0013
```
<sub><sup>Generated by a tool</sup></sub>
