Add GO (batch delimiters) where needed

arvindshmicrosoft · arvindshmicrosoft · commit d70957f8c3aa · 2021-07-31T08:47:03.000-07:00
diff --git a/docs/relational-databases/security/row-level-security.md b/docs/relational-databases/security/row-level-security.md
@@ -554,7 +554,7 @@ Create a sample schema and a fact table to hold data.
 
 ```sql
 CREATE SCHEMA Sample;
-
+GO
 CREATE TABLE Sample.Sales  
     (  
     OrderID int,  
@@ -606,7 +606,7 @@ Create a new schema, and an inline table-valued function. The function returns 1
 
 ```sql
 CREATE SCHEMA Security ;
-
+GO
 CREATE FUNCTION Security.fn_securitypredicate
          (@Product AS varchar(10))
 RETURNS TABLE
diff --git a/docs/relational-databases/tables/manage-retention-of-historical-data-in-system-versioned-temporal-tables.md b/docs/relational-databases/tables/manage-retention-of-historical-data-in-system-versioned-temporal-tables.md
@@ -130,25 +130,27 @@ To maintain a sliding window, you need to make predicate function to be accurate
 
 ```sql
 BEGIN TRAN
+GO
 /*(1) Create new predicate function definition */
-  CREATE FUNCTION dbo.fn_StretchBySystemEndTime20151102(@systemEndTime datetime2)
-   RETURNS TABLE
-    WITH SCHEMABINDING
-      AS
-        RETURN SELECT 1 AS is_eligible
-          WHERE @systemEndTime < CONVERT(datetime2,'2015-11-02T00:00:00', 101)
-  GO
+CREATE FUNCTION dbo.fn_StretchBySystemEndTime20151102(@systemEndTime datetime2)
+  RETURNS TABLE
+  WITH SCHEMABINDING
+    AS
+      RETURN SELECT 1 AS is_eligible
+        WHERE @systemEndTime < CONVERT(datetime2,'2015-11-02T00:00:00', 101)
+GO
  
 /*(2) Set the new function as filter predicate */
-  ALTER TABLE <history table name>
-    SET
-      (
-        REMOTE_DATA_ARCHIVE = ON
-          (
-            FILTER_PREDICATE = dbo.fn_StretchBySystemEndTime20151102(SysEndTime),
-              MIGRATION_STATE = OUTBOUND
-          )
-      )
+ALTER TABLE [<history table name>]
+  SET
+    (
+      REMOTE_DATA_ARCHIVE = ON
+        (
+          FILTER_PREDICATE = dbo.fn_StretchBySystemEndTime20151102(SysEndTime),
+            MIGRATION_STATE = OUTBOUND
+        )
+    )
+GO
 COMMIT ;
 ```
 
diff --git a/docs/sql-server/stretch-database/select-rows-to-migrate-by-using-a-filter-function-stretch-database.md b/docs/sql-server/stretch-database/select-rows-to-migrate-by-using-a-filter-function-stretch-database.md
@@ -38,12 +38,12 @@ ms.custom: seo-dt-2019
  The inline table-valued function required for a Stretch Database filter predicate looks like the following example.  
   
 ```sql  
-CREATE FUNCTION dbo.fn_stretchpredicate(@column1 datatype1, @column2 datatype2 [, ...n])  
+CREATE FUNCTION dbo.fn_stretchpredicate(@column1 datatype1, @column2 datatype2 /*[, ...n]*/)  
 RETURNS TABLE  
 WITH SCHEMABINDING   
 AS   
 RETURN  SELECT 1 AS is_eligible  
-        WHERE <predicate>  
+        WHERE someCol = @column1 /* replace with an actual predicate */
 ```  
   
  The parameters for the function have to be identifiers for columns from the table.  
diff --git a/docs/t-sql/functions/odbc-scalar-functions-transact-sql.md b/docs/t-sql/functions/odbc-scalar-functions-transact-sql.md
@@ -129,7 +129,7 @@ DECLARE @len INT
 SET @len = (SELECT {fn OCTET_LENGTH( @string_exp )})  
 RETURN(@len)  
 END ;  
-  
+GO
 SELECT dbo.ODBCudf('Returns the length.');  
 --Returns 38  
 ```  
@@ -203,7 +203,7 @@ DECLARE @len INT
 SET @len = (SELECT {fn BIT_LENGTH( @string_exp )})  
 RETURN(@len)  
 END ;  
-  
+GO
 SELECT dbo.ODBCudf('Returns the length in bits.');  
 --Returns 432  
 ```  
diff --git a/docs/t-sql/queries/option-clause-transact-sql.md b/docs/t-sql/queries/option-clause-transact-sql.md
@@ -37,14 +37,12 @@ monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-s
 ### Syntax for [!INCLUDE[ssnoversion-md.md](../../includes/ssnoversion-md.md)] and [!INCLUDE[ssazure_md.md](../../includes/ssazure_md.md)].
 
 ```syntaxsql
-
 [ OPTION ( <query_hint> [ ,...n ] ) ]   
 ```  
   
 ### Syntax for [!INCLUDE[sssdw-md.md](../../includes/sssdw-md.md)] and [!INCLUDE[sspdw-md.md](../../includes/sspdw-md.md)]
 
 ```syntaxsql
-  
 OPTION ( <query_option> [ ,...n ] )  
   
 <query_option> ::=  
@@ -62,7 +60,6 @@ OPTION ( <query_option> [ ,...n ] )
 ### Syntax for [!INCLUDE[sssodfull-md.md](../../includes/sssodfull-md.md)]
 
 ```syntaxsql
-
 OPTION ( <query_option> [ ,...n ] )
 
 <query_option> ::=
@@ -132,29 +129,29 @@ OPTION ( Label = 'CustJoin', HASH JOIN, MERGE JOIN);
  The following example creates a view named CustomerView and then uses a HASH JOIN query hint in a query that references a view and a table.  
   
 ```sql
--- Uses AdventureWorks  
+-- Uses the AdventureWorks sample database
   
 CREATE VIEW CustomerView  
 AS  
 SELECT CustomerKey, FirstName, LastName FROM ssawPDW..DimCustomer;  
-  
+GO
 SELECT COUNT (*) FROM dbo.CustomerView a  
 INNER JOIN dbo.FactInternetSales b  
 ON (a.CustomerKey = b.CustomerKey)  
 OPTION (HASH JOIN);  
-  
+GO
 DROP VIEW CustomerView;
+GO
 ```  
   
 ### F. Query with a subselect and a query hint  
  The following example shows a query that contains both a subselect and a query hint. The query hint is applied globally. Query hints are not allowed to be appended to the subselect statement.  
   
 ```sql
--- Uses AdventureWorks  
-  
+-- Uses the AdventureWorks sample database
 CREATE VIEW CustomerView AS  
 SELECT CustomerKey, FirstName, LastName FROM ssawPDW..DimCustomer;  
-  
+GO
 SELECT * FROM (  
 SELECT COUNT (*) AS a FROM dbo.CustomerView a  
 INNER JOIN dbo.FactInternetSales b  
diff --git a/docs/t-sql/statements/add-signature-transact-sql.md b/docs/t-sql/statements/add-signature-transact-sql.md
@@ -200,7 +200,7 @@ CREATE USER Alice;
 EXECUTE AS LOGIN = 'Alice';  
     SELECT * FROM T1;  
 REVERT;  
-  
+GO  
 -- Create a procedure that directly accesses T1  
 CREATE PROCEDURE procSelectT1 AS  
 BEGIN  
@@ -209,7 +209,7 @@ BEGIN
 END;  
 GO  
 GRANT EXECUTE ON ProcSelectT1 to public;  
-  
+GO
 -- Create special procedure for accessing T1  
 CREATE PROCEDURE  ProcForAlice AS  
 BEGIN  
diff --git a/docs/t-sql/statements/create-materialized-view-as-select-transact-sql.md b/docs/t-sql/statements/create-materialized-view-as-select-transact-sql.md
@@ -161,7 +161,7 @@ A user needs following permissions to create a materialized view in addition to
 ## Example
 A. This example shows how Synapse SQL optimizer automatically uses materialized views to execute a query for better performance even when the query uses functions un-supported in CREATE MATERIALIZED VIEW, such as COUNT(DISTINCT expression). A query used to take multiple seconds to complete now finishes in sub-second without any change in the user query.   
 
-``` sql 
+```sql 
 
 -- Create a table with ~536 million rows
 create table t(a int not null, b int not null, c int not null) with (distribution=hash(a), clustered columnstore index);
@@ -212,7 +212,9 @@ SchemaY owner = User1
 *****************************************************************/
 CREATE USER User1 WITHOUT LOGIN ;
 CREATE USER User2 WITHOUT LOGIN ;
-CREATE SCHEMA SchemaX;  
+GO
+CREATE SCHEMA SchemaX;
+GO
 CREATE SCHEMA SchemaY AUTHORIZATION User1;
 GO
 CREATE TABLE [SchemaX].[T1] (	[vendorID] [varchar](255) Not NULL, [totalAmount] [float] Not NULL,	[puYear] [int] NULL );
diff --git a/docs/t-sql/statements/create-procedure-transact-sql.md b/docs/t-sql/statements/create-procedure-transact-sql.md
@@ -854,7 +854,7 @@ END CATCH;
 
 GO
 EXEC Production.uspDeleteWorkOrder 13;
-
+GO
 /* Intentionally generate an error by reversing the order in which rows
    are deleted from the parent and child tables. This change does not
    cause an error when the procedure definition is altered, but produces
@@ -888,7 +888,7 @@ END CATCH;
 GO
 -- Execute the altered procedure.
 EXEC Production.uspDeleteWorkOrder 15;
-
+GO
 DROP PROCEDURE Production.uspDeleteWorkOrder;
 ```
 
diff --git a/docs/t-sql/statements/set-noexec-transact-sql.md b/docs/t-sql/statements/set-noexec-transact-sql.md
@@ -78,7 +78,7 @@ GO
 -- SET NOEXEC to ON.  
 SET NOEXEC ON;  
 GO  
--- Function name uses is a reserved keyword.  
+-- Function name used is a reserved keyword.  
 USE AdventureWorks2012;  
 GO  
 CREATE FUNCTION dbo.Values(@BusinessEntityID int)  
