ALTER PROCEDURE [dbo].[aspx_Orders_Update]

(

   @orderID int,

   @customerID nchar(10),

   @employeeID int,

   @orderDate datetime,

   @requiredDate datetime,

   @shippedDate datetime,

   @shipVia int,

   @freight money,

   @shipName nvarchar(80),

   @shipAddress nvarchar(120),

   @shipCity nvarchar(30),

   @shipRegion nvarchar(30),

   @shipPostalCode nvarchar(20),

   @shipCountry nvarchar(30)

)

AS

BEGIN

  SET NOCOUNT ON;

 

  UPDATE [dbo].[Orders]

  SET

  [CustomerID] = @customerID,

  [EmployeeID] = @employeeID,

  [OrderDate] = @orderDate,

  [RequiredDate] = @requiredDate,

  [ShippedDate] = @shippedDate,

  [ShipVia] = @shipVia,

  [Freight] = @freight,

  [ShipName] = @shipName,

  [ShipAddress] = @shipAddress,

  [ShipCity] = @shipCity,

  [ShipRegion] = @shipRegion,

  [ShipPostalCode] = @shipPostalCode,

  [ShipCountry] = @shipCountry

  WHERE [OrderID] = @orderID

END