Fixed delete SQL Server database records ?

Dong Lam Trien

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dong Lam Trien11y ago
I have read the link you sent me, very true to my fault, but the article does not have direction fixes
0
Syed Shanu11y ago
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/
0
Dong Lam Trien11y ago
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
0
Ankur Jain11y ago
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.
0
Syed Shanu11y ago
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+
0