When does below error occur?

Column names in each table must be unique. Column name 'PROJECT_ISSUE_ID' in table 'ISSUE_REGISTER' is specified more than once.

 Posted by vishalneeraj-24503 on 1/13/2014 | Category: Sql Server Interview questions | Views: 925 | Points: 40
Answer:

When there is already a column named PROJECT_ISSUE_ID in table ISSUE_REGISTER and we are again adding it into the same table.
Then we get above error.Because column name must be unique and we can not add same column in a same table.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response