Issues deleting records in SQL database

45 pts.
Tags:
Database
SQL Database
SQL Query
I'm having issues deleting records in a SQL database. What should I do?


Software/Hardware used:
DataShed- Sql Management Studio
1

Answer Wiki

Thanks. We'll let you know when a new response is added.
Hi
With the  help of delete statement you will easily detele the records or rows from the table. To know more about delete statement click on this: http://www.sqlcourse.com/delete.html
Thanks & Regards
Clark Kent

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Can you post a sample of your code so we can analyze it and show you how to fix it?
    133,800 pointsBadges:
    report
  • rockquery
    Thanks Clark
    45 pointsBadges:
    report
  • rockquery

    Todd,

    Below is the error message that appears when trying to delete a record from the front end of the database


    45 pointsBadges:
    report
  • ToddN2000
    No image. Would be nice if we could post images sometimes for Windows based screen shots but that would open the forums to a whole lot of spam. Can you scrape / cut paste the error message?
    133,800 pointsBadges:
    report
  • rockquery
    I thought the image was shown hopefully this one does. I could really use some help.
    45 pointsBadges:
    report
  • rockquery

    goodness how do i even cut and paste a picture here :(, nothing i do seems to be working

    ODBC-call failed.
    
    [Microsoft][SQL server Native Client 10.0][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint
    "FK_tblDHColl_DataSet_Hole_ID".The conflict occureed in databse "DS_PRODUCTION", table "dbo.tblDHColl". (#547) [Microsoft]
    [SQL Server Native Client 10.0][SQL Server] The Statement has been terminated. (#3621) [Microsoft][SQL Server]Warning:Null value is
    eliminated by an aggregate or other SET operation. (#8135)
    45 pointsBadges:
    report
  • TheRealRaven
    Nothing there seems to indicate a DELETE. The error refers to an INSERT statement. Can you please show the statement that fails?
    35,690 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: