Edit Table Rows / Records in SQL Server Management Studio ( SSMS) - SQL Server Tutorial / TSQL Tutorial Part 18

Scenario:

I know that we can write update statements to update records in a table in SQL Server Management Studio(SSMS), Is there a way to update record visually?

Solution:

Yes, SQL Server Management Studio(SSMS) let you update records by using Visual Editor. To update value in a table , follow below steps.

Step 1: 
Right click on table and then go to Edit Top 200 rows as shown below.
How to visual Edit Rows in SSMS - SQL Server Tutorial


Step 2:
Go ahead and make changes to the records as you like. I changed first name from M to Mohammed. Once done, you can close the windows and changes will be saved. If you would like to insert new record, go to last line and type all the required values.
Visual Edit or Insert Records/Rows in SSMS - SQL Server Tutorial Step by Step



4 comments:

  1. KayalMarch 30, 2019 at 12:17 AM

    great job! The author giving the present post, this is very unique and worthy content. I am waiting for your another post...

    Oracle Training in Chennai
    Oracle Training institute in chennai
    Oracle DBA Training in Chennai
    Excel Training in Chennai
    Corporate Training in Chennai
    Tableau Training in Chennai
    Social Media Marketing Courses in Chennai
    Oracle Training in Chennai
    Oracle Training institute in chennai

    ReplyDelete
  2. sathyarameshApril 22, 2019 at 1:54 AM

    I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.
    SEO Training in Chennai
    SEO Course in Chennai
    Python Training in Chennai
    RPA Training in Chennai
    Software Testing Training in Chennai
    Java Training in Chennai
    Web Designing Course in chennai
    SEO Training in Annanagar

    ReplyDelete
  3. sasiJanuary 1, 2020 at 9:56 PM

    Great experience for me by reading this blog. Thank you for wonderful article.
    Angularjs Training in Chennai
    Angularjs Training in Bangalore
    angularjs training institute in bangalore
    Angular Training in hyderabad
    best angularjs training in bangalore
    Angular course in hyderabad
    Salesforce Training in Bangalore
    Hadoop training in bangalore

    ReplyDelete
  4. hijaz shaikhJune 15, 2020 at 3:38 AM

    You there, this is really good post here. Thanks for taking the time to post such valuable information. Quality content is what always gets the visitors coming. Süßwaren

    ReplyDelete

Subscribe to: Post Comments (Atom)