|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
I have a user who has submitted a survey twice, and I have to delete the second entry.
But every user has a UserID and the data for the second submission has the same UserID (the only thing different is the fact she submitted data 5 seconds later)as this is one of the unique values used in many tables. So I have deleted data in other tables but If I try to delete it from this particulat table I can't as I am really trying to delete that ID, so how can I get rid off that record? The record is in a view if that makes any difference. |
|
#2
|
||||
|
||||
|
There should never be duplicate rows in a table. Each table should have it's own primary key that makes each record within the table unique.
You should redesign your table to add a primary key column, with a data type of Identity or UniqueIdentifier. |
![]() |
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > delete a field help? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|