Entering Data Using SQL Management Studio

Video Transcript

"Hi, my name's Dave Andrews. Today I'm going to talk to you about entering data into a SQL server using Microsoft SQL Management Studio. Let's go to the computer, and we're going to open up SQL Management Studio by clicking on the start button, going to all programs let's select SQL server and just run the Management Studio. I'm going to login using Windows authentication. And here are my databases. I'm going to expand a database. Gonna find the table that I'd like to insert some data into. I'm just going to right click on it and I'm going to say open table. Now, over here on the left-hand side of the screen after I click, rather the right-hand side, after I click open table, it's going to open up that table into an interface that resembles excel and access also has a interface like this. Basically, I can move around within the actual data of the table and I can change the data directly here just by typing within a field. Hit enter, and I'm going to save my changes that I just made to that record. It's that easy to enter data directly by using Management Studio. My name's Dave Andrews and I've just showed you how to enter data into SQL using Microsoft Management Studio."