Sql basic queries (Create table, relations ships, insert, update, and delete, select)

=>Create Table

 =====================================================================

CREATE TABLE Product

(

Id INT IDENTITY(1,1) PRIMARY KEY NOT NULL,

ProductName VARCHAR(500)

)

CREATE TABLE Orders

(

Id INT IDENTITY(1,1) PRIMARY KEY NOT NULL,

OrderName VARCHAR(100),

ProductId int,

FOREIGN KEY(ProductId) REFERENCES Product(Id)

)

=>Insert data into table

 =======================================================================

INSERT INTO Product(ProductName) VALUES('PRODUCT 1'),('PRODUCT 2')

INSERT INTO Orders(OrderName,ProductId) VALUES('ORDER 1',1)

INSERT INTO Orders(OrderName,ProductId) VALUES('ORDER 2',2)

=>Update Records

 =======================================================================

UPDATE Orders

SET OrderName='ORDER 3'

WHERE Id=2

=>Delete

 =======================================================================

DELETE FROM Orders

WHERE Id=1

=>Select

 =======================================================================

SELECT OrderName

FROM Orders

SELECT Id,OrderName

FROM Orders

SELECT *

FROM Orders

SELECT DISTINCT OrderName,Id

FROM Orders

SELECT TOP 2 OrderName

 

FROM Orders 

=>update table(Add new column)

 =======================================================================


ALTER TABLE HospitalInfo
ADD IsHealthCheckPaymentEnable bit NOT NULL
CONSTRAINT IsHealthCheckPaymentEnable_Default DEFAULT 0