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
great job! The author giving the present post, this is very unique and worthy content. I am waiting for your another post...
ReplyDeleteOracle 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
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.
ReplyDeleteSEO 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