How to edit 1000 Rows In Sql
Quick Tutorial - Editing Tables and Data in SQL Server 2016
0:00 / 0:00
Quality:
Sharing buttons:
all right I want to show you how to work
with tables in SQL Server management
studio I want to show you how to alter
the structure of the table and also how
to work with the data that's in the
table so most of this is done over here
on the left and object Explorer so I'm
going to expand the databases spot find
the database you want to work with and
it's called car dealer expand that and
then expand where it says tables and
then you can sort of find what tables
are in there look at the structure look
at the data etc so first I want to deal
with the structure the fields how the
table is designed so I've got a table
here called cars so I'm going to right
click on it and if you want to see what
it looks like or change it I'm going to
choose design so this table has five
fields in it so from here I could rename
some of these fields I could add a new
field I could change the data types so
this is how you would basically edit
your table so I'll just add a new field
to this table
I'll go ahead specify a data type so if
you make any changes if you rename a
field etc then you can either hit this
disk here to save it or just close the
table up and save it as you calls it so
another thing to know about the
management studio as you deal with
things if you open tables these tabs
will appear up here so I'm just gonna
close this tab which will end editing
this table so I'm just gonna X here make
sure I save what I changed so again
that's how you get into a table and
possibly make changes to it right-click
the table go to design but to see the
data that's in it or work with the data
then it's similar right click on the
table you want to look at and you can do
either select top 1000 or edit 200 so
I'm gonna look at the data maybe make
some changes to it so I'm going to do
the edit so now we've got just the data
that's inside the table so we can see
the fields and we can see the actual
data that's in there so if you wanted
you could change one of these fields or
update one of the fields like so and
often what I do is arrow out down to the
next row to sort of save it let me show
you what I mean by that as I'm editing a
field you'll notice a pencil over here
so whatever changes I've made here I
haven't really quite saved them until I
maybe arrow down or click down
and I need pencil goes away it's going
to add a one more field here just to
show you how it's done so if you want to
add some more fields sorry some more
records to your table just go down to
this empty row and start Tring new data
again best thing you do when you're done
entering the new row just arrow down and
it will sort of save it and again notice
the tab that's open so when you're
finished sort of looking at the data in
a table or editing it probably good idea
to just close that tab
