From the course: Microsoft SQL Server 2019 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

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 2019 Essential Training

Start my 1-month free trial

Enter data into a table using the GUI

“

- [Instructor] We can use Management Studio to start entering data into our Landon Hotel guests' table. First, we need to find it in the object explorer and then right-click on it and choose Edit Top 200 Rows. 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 guest, Katherine. Notice that as soon as you start typing, a new line appears for the next empty record below. You can just ignore this for a moment and continue working on the first record. You'll also notice that an icon on the box on the left changes to a pencil. This indicates that the information has not yet been saved in the database. When you press Tab to move over to the next cell in the Last Name column, you'll get a red warning icon. This is another visual indicator that the data hasn't yet been saved. So let's finish…

Contents