How to select, insert, update, and delete table data from SQL table by Design View

In this video I have shown how to select, insert, update and delete data in SQL Server by design view. Generally we save data in SQL Server table in two way

1. By design view
2. By SQL Script

By which technique you will use, it depends on your need and working scope

Good practice is to these by SQL script. Syntaxes are mentioned below

You can do it by Scripts also listed below
INSERT Syntax:
INSERT INTO TABLENAME(FIELD NAME) VALUES(VALUES)
GO
Here if you insert value to all field then no need to mention filed name after table name

UPDATE Syntax:
UPDATE TableName SET FieldName = Expression,FieldName = Expression,... WHERE Condition
DELETE Syntax:
DELETE TableName WHERE Condition
SELECT Syntax:
SELECT FieldNames FROM TABLE NAME
Use GO after every statement is not mandatory, but good practice

To find the code I have written in this video, join to our facebook group by clicking following link:
https://www.facebook.com/groups/ITSolution365/permalink/2716432751732278/

You can also like to our facebook Page to get all video code clicking on following link:
https://www.facebook.com/permalink.php?story_fbid=614319735703331&id=562632724205366

You can follow us on twitter clicking on following link:
https://twitter.com/ITSolut62078624

We will create thousands of video related with information technology from our practical experience and those are used in our daily work and development. Stay with us.
Do like, share and comments and subscribe to my channel and click on bell button to get notification when new video uploaded. You may suggest me to make new video with new topic.

My Channel Subscription link:
https://www.youtube.com/channel/UCoARYODbMPNO26wMpPE0R6g?sub_confirmation=1

Thanks again