Fixed delete SQL Server database records ?

Question

I use C # to insert records into SQL Server 2005 after inserted me into the table to delete records but not receive an error message you see the image attached you do know what software debugging SQL Server on http://s17.postimg.org/6wjwqdzcf/error_data.jpg

Dong Lam Trien · Answer

I have read the link you sent me very true to my fault but the article does not have direction fixes

Syed Shanu · Answer

This can be due to 1) Your table name is miss spelled. 2) Database selected might be different from your actuab DB. Kindly check for your table name and also check your Database has been used to delete your table. chk this link https://technet.microsoft.com/en-us/library/aa258716(v=sql.80).aspx http://blog.sqlauthority.com/2012/08/31/sql-server-error-fix-msg-208-invalid-object-name-dbo-backupset-invalid-object-name-dbo-backupfile/

Dong Lam Trien · Answer

tables not use primary keys only a single table I want to delete 6 rows have got MACANV = 4 http://s28.postimg.org/a1z8ldgz1/error_data2.jpg

Ankur Jain · Answer

Hi! You need to have a unique key for your table. You can add an int data type column and make it an identity field.

Syed Shanu · Answer

Check this link hope this will help you. http://blogs.lessthandot.com/index.php/datamgmt/datadesign/dealing-with-the-row-value-s-updated-or/ http://forums.asp.net/t/1121710.aspx?How+to+delete+duplicate+records+in+the+sql+server +