<div>
Or you can do this:<br />
<br />
INSERT INTO atable <br />
SELECT (list of column values) <br />
WHERE NOT EXISTS(SELECT * FROM thesametable WHERE col_1 = 'something' And col_2 = 'somethingelse')
</div>


Or you can do this:

INSERT INTO atable
SELECT (list of column values)
WHERE NOT EXISTS(SELECT * FROM thesametable WHERE col_1 = 'something' And col_2 = 'somethingelse')

<div>
<div class="content wysiwyg-content">
This statement returns an &quot;Incorrect syntax near the keyword WHERE&quot; error, and I don't understand why ...<br />
<br />
INSERT INTO atable VALUES (list of column values) WHERE NOT EXISTS<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SELECT * FROM thesametable WHERE col_1 = 'something' And col_2 = 'somethingelse')<br />
<br />
I know it has something to do with EXISTS; I confirmed that by removing the WHERE clause from the SELECT statement.<br />
<br />

</div>
</div>


This statement returns an "Incorrect syntax near the keyword WHERE" error, and I don't understand why ...

INSERT INTO atable VALUES (list of column values) WHERE NOT EXISTS
	(SELECT * FROM thesametable WHERE col_1 = 'something' And col_2 = 'somethingelse')

I know it has something to do with EXISTS; I confirmed that by removing the WHERE clause from the SELECT statement.



conditional insert using exists (AGAIN!)

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.