SQL Server Data Manipulation Examples

Write a SELECT Query

Write a SQL query to select all employees from the 'Employees' table who work in the 'Sales' department.

Expected output: A list of employees where Department = 'Sales'.

Hint: Use the WHERE clause to filter by department.

Insert Multiple Rows

Insert three new records into the 'Products' table with different product names and prices.

Expected output: Three new rows added to the Products table.

Hint: Use a single INSERT statement with multiple VALUES tuples.

Update Product Stock

Update the stock quantity of the product named 'Keyboard' to 50.

Expected output: The 'Keyboard' product's stock is updated to 50.

Hint: Use UPDATE with SET and WHERE clauses.

Delete Old Records

Delete all records from the 'Orders' table where the order date is before January 1, 2020.

Expected output: Orders before 2020-01-01 are removed.

Hint: Use DELETE with a WHERE clause filtering on the date.

DELETE removes rows one at a time and can be rolled back; it activates triggers. TRUNCATE removes all rows quickly without logging individual row deletions and cannot be rolled back in the same way.

Use the UPDATE statement with SET specifying multiple columns separated by commas, for example: UPDATE TableName SET Column1 = Value1, Column2 = Value2 WHERE Condition;

Without WHERE, these statements affect all rows in the table, which can lead to data loss or unintended changes.