Skip to content

Instantly share code, notes, and snippets.

@loonison123

loonison123/insertintowithselect.sql

Last active August 29, 2015 14:08
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save loonison123/966a1db02c6f36cb8543 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save loonison123/966a1db02c6f36cb8543 to your computer and use it in GitHub Desktop.
Download ZIP
Insert Into with select
Raw
insertintowithselect.sql
insert into [dbo].[Customer] (FirstName, LastName, DateCreated)
select
f_name,
l_name,
getdate()
from [dbo].[Cust]
-- No Where Statement, Careful!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment