USP_GET_CMSTRANSACTION_BY_ORDERID
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ORDERID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_GET_CMSTRANSACTION_BY_ORDERID
(
@ORDERID uniqueidentifier
)
as
begin
select top 1 * from dbo.CMSTRANSACTIONS where orderid = @ORDERID
end