I am getting an error mentioning "the row values updated or deleted either do not make the row unique or they alter multiple rows." what should I do? I have foreign keys in the table.
Hi Asmita. You should either use T-SQL code for this, or add another column which would make the entire row unique. An IDENTITY column would work for this purpose. Phillip
Data download link is not working
Hi Harshal. I have just tried it, and it works for me. Phillip
I am getting an error mentioning "the row values updated or deleted either do not make the row unique or they alter multiple rows." what should I do? I have foreign keys in the table.
Hi Asmita. You should either use T-SQL code for this, or add another column which would make the entire row unique. An IDENTITY column would work for this purpose. Phillip
so when we are adding the data to the tables, we do not need to save them right? The cells get automatically saved, is it?
That's right. As soon as you leave the row, it will be saved.