Introduction to SQL Server
John MacKintosh
Instructor
INSERT INTO table_name
INSERT INTO table_name (col1, col2, col3)
INSERT INTO table_name (col1, col2, col3)
VALUES
('value1', 'value2', value3)
INSERT INTO table_name (col1, col2, col3)
SELECT
column1,
column2,
column3
FROM other_table
WHERE
-- conditions apply
SELECT *
UPDATE table
SET column = value
WHERE
-- Condition(s);
WHERE
clause!UPDATE table
SET
column1 = value1,
column2 = value2
WHERE
-- Condition(s);
DELETE
FROM table
WHERE
-- Conditions
TRUNCATE TABLE table_name
Introduction to SQL Server