Skip to content

Instantly share code, notes, and snippets.

@shaneis
Created April 13, 2018 09:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save shaneis/bb514c093fda3aac3a0404c6d54fb91c to your computer and use it in GitHub Desktop.
Save shaneis/bb514c093fda3aac3a0404c6d54fb91c to your computer and use it in GitHub Desktop.
This doesn't seem to work in SQL Operations Studio
DECLARE @MyWishList TABLE (id int, Wish varchar(20));
INSERT INTO dbo.WishList (id, Wish)
OUTPUT inserted.id, inserted.Wish
INTO @MyWishList (id, Wish)
VALUES (1, 'I')
, (2, 'Want')
, (3, 'To')
, (4, 'Go')
, (5, 'To')
, (6, 'PSSummit')
, (7, 'Next year!')
SELECT * FROM @MyWishList;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment