added sql colorizer

icoric · web-flow · commit b698a113bd8b · 2020-09-17T20:41:22.000+02:00
and capitalized the keywords
diff --git a/docs/t-sql/functions/next-value-for-transact-sql.md b/docs/t-sql/functions/next-value-for-transact-sql.md
@@ -35,8 +35,7 @@ ms.author: jrasnick
   
 ## Syntax  
   
-```  
-  
+```syntaxsql
 NEXT VALUE FOR [ database_name . ] [ schema_name . ]  sequence_name  
    [ OVER (<over_order_by_clause>) ]  
 ```  
@@ -168,7 +167,7 @@ NEXT VALUE FOR [ database_name . ] [ schema_name . ]  sequence_name
   
  The following examples use a sequence named `CountBy1` in a schema named `Test`. Execute the following statement to create the `Test.CountBy1` sequence. Examples C and E use the [!INCLUDE[ssSampleDBobject](../../includes/sssampledbobject-md.md)] database, so the `CountBy1` sequence is created in that database.  
   
-```  
+```sql  
 USE AdventureWorks2012 ;  
 GO  
   
@@ -184,7 +183,7 @@ GO
 ### A. Using a sequence in a select statement  
  The following example creates a sequence named `CountBy1` that increases by one every time that it is used.  
   
-```  
+```sql  
 SELECT NEXT VALUE FOR Test.CountBy1 AS FirstUse;  
 SELECT NEXT VALUE FOR Test.CountBy1 AS SecondUse;  
 ```  
@@ -202,10 +201,10 @@ SecondUse
 ### B. Setting a variable to the next sequence value  
  The following example demonstrates three ways to set a variable to the next value of a sequence number.  
   
-```  
-DECLARE @myvar1 bigint = NEXT VALUE FOR Test.CountBy1  
-DECLARE @myvar2 bigint ;  
-DECLARE @myvar3 bigint ;  
+```sql  
+DECLARE @myvar1 BIGINT = NEXT VALUE FOR Test.CountBy1  
+DECLARE @myvar2 BIGINT ;  
+DECLARE @myvar3 BIGINT ;  
 SET @myvar2 = NEXT VALUE FOR Test.CountBy1 ;  
 SELECT @myvar3 = NEXT VALUE FOR Test.CountBy1 ;  
 SELECT @myvar1 AS myvar1, @myvar2 AS myvar2, @myvar3 AS myvar3 ;  
@@ -214,7 +213,7 @@ GO
   
 ### C. Using a sequence with a ranking window function  
   
-```  
+```sql  
 USE AdventureWorks2012 ;  
 GO  
   
@@ -227,16 +226,16 @@ GO
 ### D. Using the NEXT VALUE FOR function in the definition of a default constraint  
  Using the **NEXT VALUE FOR** function in the definition of a default constraint is supported. For an example of using **NEXT VALUE FOR** in a **CREATE TABLE** statement, see Example C[Sequence Numbers](../../relational-databases/sequence-numbers/sequence-numbers.md). The following example uses `ALTER TABLE` to add a sequence as a default to a current table.  
   
-```  
+```sql
 CREATE TABLE Test.MyTable  
 (  
-    IDColumn nvarchar(25) PRIMARY KEY,  
-    name varchar(25) NOT NULL  
+    IDColumn NVARCHAR(25) PRIMARY KEY,  
+    name VARCHAR(25) NOT NULL  
 ) ;  
 GO  
   
 CREATE SEQUENCE Test.CounterSeq  
-    AS int  
+    AS INT  
     START WITH 1  
     INCREMENT BY 1 ;  
 GO  
@@ -259,10 +258,10 @@ GO
 ### E. Using the NEXT VALUE FOR function in an INSERT statement  
  The following example creates a table named `TestTable` and then uses the `NEXT VALUE FOR` function to insert a row.  
   
-```  
+```sql  
 CREATE TABLE Test.TestTable  
-     (CounterColumn int PRIMARY KEY,  
-    Name nvarchar(25) NOT NULL) ;   
+     (CounterColumn INT PRIMARY KEY,  
+    Name NVARCHAR(25) NOT NULL) ;   
 GO  
   
 INSERT Test.TestTable (CounterColumn,Name)  
@@ -271,13 +270,12 @@ GO
   
 SELECT * FROM Test.TestTable;   
 GO  
-  
 ```  
   
 ### E. Using the NEXT VALUE FOR function with SELECT ... INTO  
  The following example uses the `SELECT ... INTO` statement to create a table named `Production.NewLocation` and uses the `NEXT VALUE FOR` function to number each row.  
   
-```  
+```sql  
 USE AdventureWorks2012 ;   
 GO  
   
@@ -293,7 +291,7 @@ GO
 ### F. Granting permission to execute NEXT VALUE FOR  
  The following example grants **UPDATE** permission to a user named `AdventureWorks\Larry` permission to execute `NEXT VALUE FOR` using the `Test.CounterSeq` sequence.  
   
-```  
+```sql  
 GRANT UPDATE ON OBJECT::Test.CounterSeq TO [AdventureWorks\Larry] ;  
 ```  
   
