Procedure: [AdventureWorks2016CTP3].[Sales].[usp_UpdateSalesOrderShipInfo_native]

CollapseAll image

Collapse image Procedure properties


 Name   Value 
 Schema   [Sales] 
 Owner   [dbo] 
 Creation date   23.10.2015 
 Type   P 
 Encrypted   
 ID   1508200423 
 Implementation type   Transact SQL 
 Is native compiled 

Collapse image Creation options


Name Value
QUOTED_IDENTIFIER ON
ANSI_NULLS ON

Collapse image Parameters


Name  Description Datatype  Max length  Type  ReadOnly
@SalesOrderID   int 4 Input  
@ShipDate   datetime2 8 Input  
@Comment   nvarchar 128 Input  
@Status   tinyint 1 Input  
@TaxRate   smallmoney 4 Input  
@Freight   money 8 Input  
@CarrierTrackingNumber   nvarchar 25 Input  

Collapse image Objects that depend on [Sales].[usp_UpdateSalesOrderShipInfo_native]


Object name Object type Dep level
[Sales].[usp_UpdateSalesOrderShipInfo_inmem] Procedure 1
Total 1 object(s)

Collapse image Objects that [Sales].[usp_UpdateSalesOrderShipInfo_native] depends on


Object name Object type Dep level
[Sales] Schema 1
Total 1 object(s)

Collapse image SQL


SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE Sales.usp_UpdateSalesOrderShipInfo_native
    @SalesOrderID int , 
    @ShipDate datetime2,
    @Comment nvarchar(128),
    @Status tinyint,
    @TaxRate smallmoney,
    @Freight money,
    @CarrierTrackingNumber nvarchar(25)
WITH NATIVE_COMPILATION, SCHEMABINDING
AS
BEGIN ATOMIC WITH
  (TRANSACTION ISOLATION LEVEL = SNAPSHOT,
   LANGUAGE = N'us_english')

    DECLARE @now datetime2 = SYSDATETIME()

    UPDATE Sales.SalesOrderDetail_inmem 
    SET CarrierTrackingNumber = @CarrierTrackingNumber, ModifiedDate = @now
    WHERE SalesOrderID = @SalesOrderID

    UPDATE Sales.SalesOrderHeader_inmem
    SET RevisionNumber = RevisionNumber + 1,
        ShipDate = @ShipDate,
        Status = @Status,
        TaxAmt = SubTotal * @TaxRate,
        Freight = @Freight,
        ModifiedDate = @now
    WHERE SalesOrderID = @SalesOrderID

END
GO

Collapse image See also


List of procedures