Advertisement
bisonn

Untitled

Nov 26th, 2019
246
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.59 KB | None | 0 0
  1. ALTER PROCEDURE [dbo].[Reserv_InsertPP]
  2.     -- Add the parameters for the stored procedure here
  3.     @Article varchar(50),
  4.     @Varcode varchar(50),
  5.     @Colour varchar(50),
  6.     @Vendor varchar(50),
  7.     @Quantity varchar(50),
  8.     @ItemNo varchar(20)
  9. AS
  10. BEGIN
  11.     -- SET NOCOUNT ON added to prevent extra result sets from
  12.     -- interfering with SELECT statements.
  13.     SET NOCOUNT ON;
  14.  
  15.     -- Insert statements for procedure here
  16.    
  17.     insert into [dbo].[Reserv_PP] with (rowlock)
  18.     ([Artikul], [Varcode], [Colour], [Vendor], [Quantity], [ItemNo])
  19.     values (@Article, @Varcode, @Colour, @Vendor, @Quantity, @ItemNo)
  20.  
  21.  
  22. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement