Skip to content

Instantly share code, notes, and snippets.

@bartubozkurt

bartubozkurt/insertinto_select_statement.sql

Created June 12, 2021 21:31
Show Gist options
  • Save bartubozkurt/da356b05915c430ccd89ec1bf4165bd6 to your computer and use it in GitHub Desktop.
Save bartubozkurt/da356b05915c430ccd89ec1bf4165bd6 to your computer and use it in GitHub Desktop.
Download ZIP
You can also create more complicated SQL Server INSERT statements using SELECT statements
Raw
insertinto_select_statement.sql
INSERT INTO contacts (contact_id, last_name, first_name)
SELECT employee_id, last_name, first_name
FROM employees
WHERE employee_id <= 100;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment