Views [dbo].[vCustomerInformation]
BUILD07\MSSQLSERVER2008 > MoversSuite2 > Views > dbo.vCustomerInformation
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created2:40:04 AM Wednesday, March 29, 2017
Last Modified2:41:43 AM Wednesday, March 29, 2017
Columns
Name
CustomerNumber
CustomerName
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE view [dbo].[vCustomerInformation]
(
    CustomerNumber,
    CustomerName
)
as
select
    CustomerNumber = RM00101.CUSTNMBR,
    CustomerName = ltrim( rtrim( RM00101.CUSTNAME ) )
from CAROL..RM00101 as RM00101
GO
GRANT SELECT ON  [dbo].[vCustomerInformation] TO [MssExec]
GRANT INSERT ON  [dbo].[vCustomerInformation] TO [MssExec]
GRANT DELETE ON  [dbo].[vCustomerInformation] TO [MssExec]
GRANT UPDATE ON  [dbo].[vCustomerInformation] TO [MssExec]
GO
Uses
Used By
Created 05 April 2017 10:53
Copyright  2017 - All Rights Reserved