SQL Data Manipulation - Microsoft Learn

Introduction to Data Manipulation

Data manipulation is a core aspect of database management. It involves modifying the data stored within your database. This section will cover various techniques and concepts related to data manipulation.

INSERT

The INSERT statement is used to add new rows to a table.

                
                    INSERT INTO Employees (FirstName, LastName, Email)
                    VALUES ('John', 'Doe', 'john.doe@example.com');

UPDATE

The UPDATE statement is used to modify existing rows in a table.

                
                    UPDATE Employees
                    SET Email = 'john.new_email@example.com'
                    WHERE FirstName = 'John';

DELETE

The DELETE statement is used to remove rows from a table.

                
                    DELETE FROM Employees
                    WHERE LastName = 'Doe';

SELECT with WHERE Clause

Filtering data with the `WHERE` clause.

                
                    SELECT *
                    FROM Employees
                    WHERE Department = 'Sales';

Explore Related Topics

Learn more about using SQL to manipulate your data.