CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition
Create Table Code
CREATE TABLE table name
(
column_name1 data type
column_name2 data type,
column_name3 data type,
....
)
Primary Key Code
CREATE TABLE Zain
(
Z_Id int NOT NULL,
LastName varchar(200) NOT NULL,
FirstName varchar(200),
Address varchar(200),
City varchar(200),
PRIMARY KEY (Z_Id)
)
Unique Key Code
CREATE TABLE Zain
(
Z_Id int NOT NULL,
LastName varchar(200) NOT NULL,
FirstName varchar(200),
Address varchar(200),
City varchar(200),
UNIQUE (Z_Id)
)
Foreign Key Code
CREATE TABLE order
(
O_Id int NOT NULL,
OrderNo int NOT NULL,
P_Id int,
PRIMARY KEY (O_Id),
FOREIGN KEY (P_Id) REFERENCES Persons(P_Id)
)
Create DataBase Code
CREATE DATABASE database_name
Select Into Code
SELECT *
INTO new_table_name [IN externaldatabase]
FROM old_tablename
Select Code
SELECT column_name(s)
FROM table_nameSELECT * FROM table_name
Update Code
UPDATE table_name
set column1=value, column2=value2,..
WHERE some_column=some_value
Insert Code
INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)
Delete Code
DELETE FROM table_name
WHERE some_column=some_value
Order By Code
SELECT column_name(s)
FROM table_name
ORDER BY column_name(s) ASC|DESC
Drop Code
DROP INDEX index_name ON table_name
DROP INDEX index_name
DROP TABLE table_name
DROP DATABASE database_name
Between Code
SELECT column_name(s)
FROM table_name
WHERE column_name
BETWEEN value1 AND value2
Alias Code
SELECT column_name(s)
FROM table_name
AS alias_name SELECT column_name AS alias_name
FROM table_name
Top Code
SELECT TOP number|percent column_name(s)
FROM table_name
Like Code
SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern
In code
SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...)
Check Code
CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
CHECK (P_Id>0)
)
Create Index Code
CREATE INDEX index_name
ON table_name (column_name)CREATE UNIQUE INDEX index_name
ON table_name (column_name)
Date Code
SELECT * FROM Orders WHERE OrderDate='2010-1-11'
Group By Code
SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name
Sum Code
SELECT SUM(column_name) FROM table_name
Having Code
SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name
HAVING aggregate_function(column_name) operator value
SELECT SUM(column_name) FROM table_name
Ucase Code
SELECT UCASE(column_name) FROM table_name
SELECT UPPER(column_name) FROM table_name
Icase Code
SELECT LCASE(column_name) FROM table_name
SELECT LOWER(column_name) FROM table_name
Mid Code
SELECT MID(column_name,start[,length]) FROM table_name
Round Code
SELECT ROUND(column_name,decimals) FROM table_name
Now Code
SELECT NOW() FROM table_name
Formate Code
SELECT FORMAT(column_name,format) FROM table_name
Max Code
SELECT MAX(column_name) FROM table_name
AVG Code
SELECT AVG(column_name) FROM table_name
Count Code
SELECT COUNT(column_name) FROM table_name
SELECT COUNT(*) FROM table_name
Last Code
SELECT LAST(column_name) FROM table_name
Inner Join Code
SELECT column_name(s)
FROM table_name1
INNER JOIN table_name2
ON table_name1.column_name=table_name2.column_name
Left Join Code
SELECT column_name(s)
FROM table_name1
LEFT JOIN table_name2
ON table_name1.column_name=table_name2.column_name
Right Join Code
SELECT column_name(s)
FROM table_name1
RIGHT JOIN table_name2
ON table_name1.column_name=table_name2.column_name
Full Join Code
SELECT column_name(s)
FROM table_name1
FULL JOIN table_name2
ON table_name1.column_name=table_name2.column_name
