The sql script editor is not fully compliant with OSQL but these extra syntax words can be used :
' to make a comment
GO = to execute the previous query
sample report:
Code:
' This is a sample report
' Always start the name of your views with "web30rep"
'Create the view
CREATE VIEW dbo.web30rep...
AS
SELECT ...
GO
'Add the view to the reports table
INSERT INTO ...
GO
'Add the report to the reports page
INSERT INTO ... VALUES (...)
