MSSQL / TSQL "GO" batch operator

Avatar
  • updated
  • Under review

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'."

 

Avatar
Dave

Yup, still wishing Flyspeed supported the "GO" operation that MSSMS offers...