Using 2 same values in 1 row -> SQL 2008 table

Question

I've searched for this thingy a lot.. and I can not find a solution since I'm beginner in SQL itself.

I used to edit games database. now, I need to create a new table with 1 row called "CodeName128" and it should contain the same value many times.. when I place something like

CODE_NAME1
CODE_NAME1

it tells me No rows was updated blabla which means this table already have this code.

how can I get over it and enable the duplication in table?

Live example: enter image description here

You have a primary key constraint on the column. A primary key enforces uniqueness on values. — gvee
– gvee, Commented Sep 17, 2013 at 14:03
Use a unique key instead of one already in the db so SQL server can see it's a new row — Anthony
– Anthony, Commented Sep 17, 2013 at 14:05

Sonam · Accepted Answer · 2013-09-17 14:03:42Z

1

You must be having Primary key or Unique key defined on that column which is not allowing you to enter the duplicate values. The keys must be defined for a reason, so its not advisable to remove those, still if you think that duplicate values are required for that column, you have to alter the table structure and remove those constraints from that column.

answered Sep 17, 2013 at 14:03

Sonam

3,4861 gold badge14 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using 2 same values in 1 row -> SQL 2008 table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related