Created
April 13, 2018 09:22
-
-
Save shaneis/bb514c093fda3aac3a0404c6d54fb91c to your computer and use it in GitHub Desktop.
This doesn't seem to work in SQL Operations Studio
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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