Advertisement
Guest User

Untitled

a guest
Sep 3rd, 2015
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. USE [Tomasos]
  2. GO
  3. /****** Object: StoredProcedure [dbo].[createOrder] Script Date: 2015-09-03 10:14:14 ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8. ALTER procedure [dbo].[createOrder]
  9. @bestallningDatum datetime,
  10. @totalBelopp int,
  11. @levererad bit,
  12. @kundID int ,
  13. @output int output
  14. as
  15. insert into Bestallning (BestallningDatum, Totalbelopp, Levererad, KundID)
  16. values (@bestallningDatum, @totalBelopp, @levererad, @kundID)
  17. set @output = scope_identity()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement