The supplied file maskviews.sql had malformed SQL.
Error Message:
******************************
Changed database context to 'Scramble'.
Msg 156, Level 15, State 1, Server <<SERVER_NAME>>, Procedure ORDERS_v, Line 8
Incorrect syntax near the keyword 'from'.
Please review the following script that was generated from Subset:
use [Scramble]
GO
IF EXISTS(SELECT 1 FROM sys.views
WHERE object_id = OBJECT_ID('[dbo].[ORDERS_v]')) BEGIN
DROP VIEW [dbo].[ORDERS_v]
END
GO
CREATE VIEW [dbo].[ORDERS_v] as select
[ord_num] [ord_num],
[cust_id] [cust_id],
[prod_id] [prod_id],
[qty] [qty],
[order_date] [order_date],
dbo.selectCAR_PARTS(200,CAST(description AS VARCHAR(1)),'') [description] from [Sales].[dbo].[ORDERS] L0 where 1 = 1 GO
Please note this line fragment:
dbo.selectCAR_PARTS(200,CAST(description AS VARCHAR(1)),'') [description]
The double quotes are incorrect. It should be a single and not doubles.