Procedure:
[AdventureWorks2016CTP3].[Sales].[usp_UpdateSalesOrderShipInfo_native]
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 | ![]() |
Creation options
| Name | Value |
| QUOTED_IDENTIFIER | ON |
| ANSI_NULLS | ON |
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 |
Objects that depend on [Sales].[usp_UpdateSalesOrderShipInfo_native]
| Object name | Object type | Dep level |
| [Sales].[usp_UpdateSalesOrderShipInfo_inmem] | Procedure | 1 |
Objects that [Sales].[usp_UpdateSalesOrderShipInfo_native] depends on
| Object name | Object type | Dep level |
| [Sales] | Schema | 1 |
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 |
See also