All language subtitles for AddSTatement

We're going to show how to add data in the database.

Select the table, selected script as, insert to, new query Editor, from that query, we can add data

even if there is another way we can add data where you right-click

on the table, then you select Edit data.

You can add data from there.

But this is another way of adding data in the database.

You create a query, then you write code of adding data in the database.

You will rwite the code: use Point-of-sale as a database, go, inset into the table [table name], item

size.

Then the you can see the column item says value

We can add for example, kilogramme, then go.

If you click execute.

It shows that one row is affected, which means it saves successfully.

We can add more data like one litre,

two litre for example.

Yeah, it's being saved in the database as you can see.

When it's writtenone affected, it means it's added to one row in the database.

Then you can close when you finish with adding data in the database.

This is a one way of adding data.

You can also : right-click, then you click on edit top twenty row, for example, you can add

data.

from there you can add data.

That's the two way you can add data from the database.

But if you have like a Point-of-sale application, C Sharp application, you can use it

you can use it for adding data.

This is the way you use for adding data using SQL Server query.

You can add more data.

If you add the data you click on execute.

It shows the row affected, which means the data is inserted in the database successfully.

Right-Click

on the table.

If you click on edit top twenty rows, you can add data from there without writing code. But writting codes

right-Click

on the table, then select the script of adding data

right-Click on the table, then select top 1000 row or select a top 200 rows.

It will show you all data in the database.

That's the way you can see the data in the database.

If you try to add also more data in the table: item size, Insert into item size, Column name then value.

For example, we add a can of coke, for example.

A can we add it as a size.

We're going to use that size

As I told you in the relationship or in designing process, it will help .

for not writting same size in the table. Not to repeat writing something many times when adding data in the database.

Right-Click

then.

You selected the query for adding data, then you can write the code yourself, or right-click

Right-Click

on the table, then you select edit top 200 rows.

It will show you where you can edit and add data.

You can add data from there without writing code.

Thank you so much.

Hope you enjoyed this course.

See you for the next lecture bye.