If you are adding values for all the columns of the table, you do not need to specify the column names in the SQL query. However, make sure the order of the values is in the same order as the columns in the table.

	INSERT INTO table_name
	VALUES (value1, value2, value3, ...);

bartubozkurt / insert_example.sql

Created June 12, 2021 21:27

	INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
	VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway');

bartubozkurt / specific_insert.sql

Created June 12, 2021 21:28

insert data in specific columns.

	INSERT INTO Customers (CustomerName, City, Country)
	VALUES ('Cardinal', 'Stavanger', 'Norway');

bartubozkurt / insert_into_multiple_records.sql

Created June 12, 2021 21:29

INSERT statement when inserting multiple records

	INSERT INTO Employees (employee_id, last_name, first_name)
	VALUES
	(10, ‘Bozkurt’,’Bartu’),
	(11, ‘Anderson,’Sarah’);

bartubozkurt / insertinto_select_statement.sql

Created June 12, 2021 21:31

You can also create more complicated SQL Server INSERT statements using SELECT statements

	INSERT INTO contacts (contact_id, last_name, first_name)
	SELECT employee_id, last_name, first_name
	FROM employees
	WHERE employee_id <= 100;

bartubozkurt / set.sql

Created June 12, 2021 21:32

The SET command is used with UPDATE to specify which columns and values that should be updated in a table.

	UPDATE Customers
	SET ContactName = 'Alfred Schmidt', City= 'Frankfurt'
	WHERE CustomerID = 1;

bartubozkurt / delete.sql

Created June 12, 2021 21:32

The DELETE statement is used to delete existing records in a table.

DELETE FROM Customers WHERE CustomerName='Alfreds Futterkiste';

bartubozkurt / delete_condition.sql

Created June 12, 2021 21:33

	DELETE FROM employees
	WHERE last_name = ‘Johnson' AND employee_id >= 80;

Older Newer