CREATE PROCEDURE BookUpdateRecord

	@BookID	varchar(36),
	@Title		nvarchar(200),
	@Description	ntext,
	@AuthorName	nvarchar(200),
	@Publisher	nvarchar(200),
	@ISBN		varchar(20),
	@Price		varchar(50),
	@Link		varchar(200),
	@OldName	varchar(200),
	@updUser	varchar(36),
	@updDate	datetime
  AS
	UPDATE Book
	SET
		Title	=@Title,
		Description	=@Description ,
		AuthorName	=@AuthorName ,
		Publisher	=@Publisher ,
		ISBN		=@ISBN ,
		Price		=@Price ,
		Link		=@Link ,
		OldName	=@OldName,
		updUser	=@updUser,
		@updDate	=@updDate
	WHERE
		BookID =@BookID
GO1