SQL
Truncate Table Usage in …
TRUNCATE TABLE statement is used to delete the data inside a table, but not the table itself. 1-- …
Inner Join Usage in SQL
INNER JOIN keyword selects records that have matching values in both tables. Here is the sample of …
Drop Table Usage in SQL
DROP TABLE statement is used to drop an existing table in a database. WARNING Be careful before …
Where Clause Usage in SQL
WHERE clause is used to filter records. 1SELECT column1, column2, ... 2FROM table_name 3WHERE …
Join Usage in SQL
JOIN clause is used to combine rows from two or more tables, based on a related column between them. …
Right Join Usage in SQL
RIGHT JOIN keyword returns all records from the right table (table 2), and the matching records from …
Update Table Usage in SQL
UPDATE statement is used to modify the existing records in a table. 1UPDATE table_name 2SET column1 …
Full Join Usage in SQL
FULL OUTER JOIN keyword returns all records when there is a match in left (table 1) or right (table …
Left Join Usage in SQL
LEFT JOIN keyword returns all records from the left table (table 1), and the matching records from …
Select Table Usage in SQL
SELECT statement is used to retrieve data/records from one or more tables in SQL Database 1SELECT * …
Backup Database for Sql …
BACKUP DATABASE statement is used in SQL Server to create a full back up of an existing SQL …
INSERT Table Usage in SQL
INSERT statement is used to insert new records in a table. 1INSERT INTO table_name (column1, …