Skip to content

Instantly share code, notes, and snippets.

@bananu7
Created December 2, 2013 23:14
Show Gist options
  • Select an option

  • Save bananu7/7760850 to your computer and use it in GitHub Desktop.

Select an option

Save bananu7/7760850 to your computer and use it in GitHub Desktop.
--DECLARE @czas TABLE (czasid int)
CREATE TABLE #tempczas (czasid int)
INSERT INTO Czas (id,x)
OUTPUT INSERTED.id INTO #tempczas(czasid)
VALUES (2,5);
declare @czasid int
set @czasid = (select * from #tempczas)
INSERT INTO Sprzedaż (id,czas)
VALUES (1, @czasid);
SELECT * FROM Sprzedaż;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment