[dbo].[MssWebGetPaymentMethods]
BUILD09
>
MoversSuite2
>
Stored Procedures
> dbo.MssWebGetPaymentMethods
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]
.
[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