MSSQL / TSQL "GO" batch operator
I'm trying to clean up some table before running a query, and what follows WORKS in MS SQL Server Management Studio 17.3, but fails in Flyspeed 3.7.2.2
I know in MSSMS that there's a place to define the batch operator name "GO", but I can't find a similar field anywhere in Flyspeed. This is the only thing I can identify as my issue. Yup, the more I read, the more it looks like a MSSMS feature, and not a MSSQL server feature.
Ideas how I can similarly execute a batch "GO" command in flyspeed?
Thx, Dave
"Error executing query:
IF object_id('SBTEMP','v') is not null
DROP VIEW SBTEMP;
GO
CREATE VIEW dbo.SBTEMP as
SELECT
CALG.dbo.Item.ExtendedDescription,
CALG.dbo.Item.BinLocation,
CALG.dbo.Item.DepartmentID,
CALG.dbo.Department.Name AS Department,
CALG.dbo.Item.CategoryID,
CALG.dbo.Category.Name AS Category,
CALG.dbo.Item.LastSold,
CALG.dbo.Item.ID
FROM
CALG.dbo.Supplier
LEFT JOIN CALG.dbo.Item ON CALG.dbo.Item.SupplierID = CALG.dbo.Supplier.ID
LEFT JOIN CALG.dbo.Category ON CALG.dbo.Category.ID = CALG.dbo.Item.CategoryID
LEFT JOIN CALG.dbo.Department ON CALG.dbo.Item.DepartmentID = CALG.dbo.Department.ID
WHERE
CALG.dbo.Supplier.SupplierName = 'Hammond Manufacturing'
Message:
[FireDAC][Phys][ODBC][Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'GO'."
Yup, still wishing Flyspeed supported the "GO" operation that MSSMS offers...