Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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