How to table join in sql

SELECT Product.ProductID, Client.ClientName, Product.ProductDate

FROM Product

INNER JOIN Client

ON Product.ClientID=Client.ClientID;

How to delete data in database sql server

DELETE FROM Client

WHERE Name='Dovi' AND Clientname='Mmoi';

All Data Delete:

DELETE FROM Client;

How to update data in sql server database

UPDATE Client

SET Name='Dovi', City='London'

WHERE CustomerName='Musha';

Click to execute .

How to insert data in sql database 

INSERT INTO Client
VALUES (name,address,City,...);

 

Column name and values :

INSERT INTO Client(name,address,city,...)
VALUES (kolom,span,vigas,...);

How to create table in sql server

Client Table :

Product Table:

Output

How to Add TextArea in mvc ( Code First )

How to create Registration Form in asp.net mvc5 (code first)

Model:

Department :

Student :

DBContext

Output :