1. Ordering of the execution of the SELECT statement
clauses:
- Refers to the order in which the SELECT clauses are processed. The order is usually FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY. SQL Server generally executes clauses in a logical and efficient order, even if they are not specified in that order.
2. Select and sort records (
ORDER BY):
- The ORDER BY clause is used to sort query results in ascending or descending order based on one or more columns. Example:
SELECT column1, column2
FROM your_table
ORDER BY column1 ASC, column2 DESC;
3. Select and group records (
GROUP BY):
- The GROUP BY clause is used to group rows that have the same values in certain columns in summary. Example:
SELECT column1, COUNT(*)
FROM your_table
GROUP BY column1;
4. Insert Record Into Table (INSERT):
- The INSERT statement is used to add new records to a table. Example:
INSERT INTO your_table (column1, column2)
VALUES (value1, value2);
5. Update Existing Record (UPDATE):
- The UPDATE statement is used to modify the values in a table. Example:
UPDATE your_table
SET column1 = new_value1
WHERE condition;
6. Delete Existing Record (DELETE):
- The DELETE statement is used to remove records from a table based on a condition. Example:
DELETE FROM your_table
WHERE condition;
These are fundamental operations in SQL Server Management Studio (SSMS) that enable the manipulation of data in tables. The SELECT, INSERT, UPDATE, and DELETE operations are the basis for interacting with the data stored in a database. SSMS provides a graphical interface to perform these operations and view the results.