From the course: Microsoft SQL Server 2022 Essential Training

Unlock this course with a free trial

Join today to access over 23,400 courses taught by industry experts.

Enter data into a table using the GUI

Enter data into a table using the GUI - SQL Server Tutorial

From the course: Microsoft SQL Server 2022 Essential Training

Start my 1-month free trial Buy for my team

Enter data into a table using the GUI

“

- [Instructor] We can use Management Studio's graphical interface to start entering data into our Red30Tech customers table. We first need to locate it in the Object Explorer panel. Remember, it's underneath the database file, and then in the tables folder, and you'll find the customers table there. Then right click on it, and choose edit top 200 rows from the popup menu. This will bring up a table grid on the right and display the column names that we created along the top. On the next line is the space for our first record, and currently every cell on the table is empty or null. I'll type in the first name of our first customer, Katherine. Notice that as soon as you start typing, a new line appears for the next empty record below. You can just ignore this line for a moment and continue working on the first record's values. You'll also notice that the icon in the box on the left changes to a pencil. This indicates that…

Contents