locked
How to Delete Single Entry from Data Base. RRS feed

All replies

  • Hi,

    Can you post your full requirement so that we can help? What you trying to achieve?


    Kindly mark the reply as answer if they help

    Thursday, December 1, 2016 8:25 AM
  • Hi Tawqeer,

    Could you please give more information and the scenario about this question to us for analysis? My understanding is that you want to delete Row from the table in SQL Server database.

    You can select one from the following methods:

    1. Using SQL Server Management Studio (SSMS):

    a. You can open SSMS, connect to the instance which included this database.
    b. Expend the folder Database, find the database included the table, find the table and right-click on it, select Edit Top 200 Rows, then find the row you want to delete and right-click on it and select Delete.

    2. Using T-SQL, please use the following query:

    USE [Database_name];
    GO
    DELETE FROM [Table_name] 
    WHERE [Column_name=****];
    GO
    

    Best Regards,
    Teige

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Proposed as answer by Teige Gao Wednesday, December 21, 2016 8:11 AM
    Friday, December 2, 2016 7:49 AM
  • DELETE command along with WHERE condition deletes the single entry from the table...

    BEGIN TRAN

    DELETE FROM tbl WHERE...

    Have you seen 1 rows affected  text message after running the statement ? If yes issue COMMIT TRAN 


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Sunday, December 4, 2016 6:56 AM