[dbo].[MssWebGetCommodityDetails]
BUILD09
>
MoversSuite2
>
Stored Procedures
> dbo.MssWebGetCommodityDetails
Properties
Permissions
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Permissions
Type
Action
Owning Principal
Grant
Execute
MssExec
SQL Script
CREATE
PROCEDURE
[dbo]
.
[MssWebGetCommodityDetails]
AS
SET
NOCOUNT
ON
SELECT
[Key]
=
CommodityDetailID
,
[Value]
=
[Description]
FROM
CommodityDetail
ORDER
BY
[Description]
GO
GRANT
EXECUTE
ON
[dbo]
.
[MssWebGetCommodityDetails]
TO
[MssExec]
GO
Uses
[dbo].[CommodityDetail]
dbo