Stored Procedures [dbo].[MssWebGetCommodityDetails]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Permissions
TypeActionOwning Principal
GrantExecuteMssExec
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