<div>
You mean you want to explicitly set the ID. Is it an IDENTITY column?
</div>


You mean you want to explicitly set the ID. Is it an IDENTITY column?

<div>
Stalhw<br />
Thanks so much - it solved my problem. &nbsp;<br />
<br />
(FYI: Works perfect - but by the way I had to use identity_Insert with an underline between the two words)
</div>


Stalhw
Thanks so much - it solved my problem.  

(FYI: Works perfect - but by the way I had to use identity_Insert with an underline between the two words)

<div>
<div class="content wysiwyg-content">
I have an existing table with CrewID as the Primary Key. &nbsp;I want to add a crew (&lt;-- Unknown Crew --&gt;) with a CrewID = 0.<br />
<br />
Any help is greatly appreciated <br />
LJG
</div>
</div>


I have an existing table with CrewID as the Primary Key.  I want to add a crew (<-- Unknown Crew -->) with a CrewID = 0.

Any help is greatly appreciated 
LJG

Existing Table - Column id --&gt; Primary Key - Want to add value --&gt;0

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.

Existing Table - Column id --&gt; Primary Key - Want to add value --&gt;0

Existing Table - Column id --> Primary Key - Want to add value -->0