<div>
<div class="content wysiwyg-content">
Hi, I am trying to insert with this option IGNORE that I usually used with MySQL insert statement<br />
<br />
INSERT IGNORE INTO table VALUES .....<br />
<br />
<br />
, but I wonder if MS SQL has something familiar to this IGNORE statement?
</div>
</div>


Hi, I am trying to insert with this option IGNORE that I usually used with MySQL insert statement

INSERT IGNORE INTO table VALUES .....


, but I wonder if MS SQL has something familiar to this IGNORE statement?

is there sql 2000 equivalent of INSERT IGNORE?

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.