Solution for updating a record when you require a particular field Unique <p>I have a table </p> <pre><code>ProjectID ProjectName Project description </code></pre> <p>Project Name is required to be unique. To implement the unique logic, i am sending the name of the project name to Stored Procedure as </p> <pre><code>Create proc CheckName @Project Name as begin select count(ProjectName) where ProjectName=@Project Name </code></pre> <p>it return count to CS page and i check that as if(count>0) { //Add }</p> <p>This code works fine with addition. Now when i want to update the project description field, the check for Project Name again goes and it return Count 1 (which is obvious) and display Project Name already exist and i am not able to update other field of the table.</p> <p>What other Logic can be implemented to maintain the unique field in the table. Thanks for any assistance. </p>