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



9 comments:

  1. 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
  2. thagukaviMay 6, 2021 at 8:38 AM

    Amazing Post. keep update more information.
    Web Designing Course in chennai
    web Designing Training in Chennai
    Web Designing Course Online

    ReplyDelete
  3. VijayakashMay 19, 2021 at 11:12 PM

    This blog is a great source of information which is very useful for me.

    graphic design courses in tambaram
    graphic design courses in Porur
    graphic design courses in Chennai

    ReplyDelete
  4. JothiOctober 30, 2021 at 2:26 AM

    Nice blog to read. Thanks.
    Full Stack Developer Online Training
    Full Stack Online Course

    ReplyDelete
  5. mohsinkhatriApril 2, 2022 at 12:05 AM

    I read your blog frequently and I just thought I’d say keep up the amazing work! hire management training service

    ReplyDelete
  6. mohsinApril 9, 2022 at 8:37 PM

    This is very interesting content! I have thoroughly enjoyed reading your points and have come to the conclusion that you are right about many of them. You are great. https://skill5678s-site.yolasite.com

    ReplyDelete
  7. mohsinApril 23, 2022 at 12:48 AM

    Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. Singapore best management training

    ReplyDelete
  8. mohsinMay 1, 2022 at 10:10 AM

    Carts crafted of inexpensive plastic can take in the terpenes with the hemp oil inside of. best management training in singapore

    ReplyDelete
  9. ZiyaSeptember 28, 2023 at 11:28 PM

    its very helpful and interesting blog post erp software in chennai

    ReplyDelete

Subscribe to: Post Comments (Atom)