[dbo].[MssWebGetPaymentMethods]

BUILD09 > MoversSuite2 > Stored Procedures > dbo.MssWebGetPaymentMethods

Properties
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Permissions

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

Create PROCEDURE [dbo].[MssWebGetPaymentMethods]
as
set nocount on

select
    PaymentMethodId=PayMethodID ,
    PaymentMethodName=Method
from PayMethod
order by Method
GO
GRANT EXECUTE ON  [dbo].[MssWebGetPaymentMethods] TO [MssExec]
GO

Uses

[dbo].[PayMethod]
dbo