<div>
yes, you can, using the SET IDENTITY_INSERT syntax:<br />
<a href="http://msdn.microsoft.com/en-us/library/ms188059.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms188059.aspx</a>
</div>


yes, you can, using the SET IDENTITY_INSERT syntax:
http://msdn.microsoft.com/en-us/library/ms188059.aspx [http://msdn.microsoft.com/en-us/library/ms188059.aspx]

<div>
never tried it, but looks like you can with IDENTITY_INSERT<br />
<a href="http://www.sqlteam.com/article/how-to-insert-values-into-an-identity-column-in-sql-server" rel="ugc">http://www.sqlteam.com/article/how-to-insert-values-into-an-identity-column-in-sql-server</a>
</div>


never tried it, but looks like you can with IDENTITY_INSERT
http://www.sqlteam.com/article/how-to-insert-values-into-an-identity-column-in-sql-server [http://www.sqlteam.com/article/how-to-insert-values-into-an-identity-column-in-sql-server]

<div>
Hey Thanks. &nbsp;One more question. &nbsp;If I insert a row higher than the identity counter for my table, will that identity value be skipped ny SQL Server in the future or will I end up with a duplicate key situation?<br />
<br />
Thanks again.<br />
hefterr
</div>


Hey Thanks.  One more question.  If I insert a row higher than the identity counter for my table, will that identity value be skipped ny SQL Server in the future or will I end up with a duplicate key situation?

Thanks again.
hefterr

<div>
<div class="content wysiwyg-content">
Hi,<br />
I have an integer key that is an IDENTITY starting at 100. &nbsp;Can I INSERT a row and specify the identity key value if it's less than 100? &nbsp;Can I ever specify the IDENTITY value in an INSERT?<br />
<br />
Thanks,<br />
hefterr
</div>
</div>


Hi,
I have an integer key that is an IDENTITY starting at 100.  Can I INSERT a row and specify the identity key value if it's less than 100?  Can I ever specify the IDENTITY value in an INSERT?

Thanks,
hefterr

Adding a row keyed by an IDENTITY

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.