Ignite 2021 - Azure Stream Analytics SQL improvements

Published Nov 03 2021 09:00 AM 670 Views
Microsoft

New built-in functions and improvements for Azure Stream Analytics SQL

 

This article will focus on the most recent updates on ASA for the query language. The rest of the announcements can be found on the main Ignite Fall 2021 post.

 

Azure Stream Analytics is a fully managed streaming engine with user-friendly user-interface and a simple SQL language. If our language is already very close to T-SQL, the flavor of SQL used in SQL Server and Azure SQL, we are working on closing the gap completely. To that goal, we are extending existing functions, and adding new ones, that will simplify queries for the most common tasks and bring stream and batch closer together. 

 

If all these capabilities were already available in Stream Analytics via User Defined Functions, having them supported by built-in functions reduce query complexity, improve performance, and eventually will make queries more easily portable to T-SQL. 

 

New built-in functions:  

Each function is documented with examples and remarks. They are intended to function as closely as possible as their T-SQL counterparts. 

ASA New SQL Functions - Ignite 2021.png

  • CONCAT_WS : returns a string resulting from the concatenation of string values in an end-to-end manner with a separator 
  • LEFT / RIGHT : returns the left or right part of a string with the specified number of characters 
  • NULLIF : returns a null value if the two specified expressions are equal, the first if not 
  • REPLICATE : repeats a string value a specified number of times 
  • REVERSE : returns the reverse order of a string value 
  • SPACE : returns a string of repeated spaces 
  • STUFF : inserts a string into another string 
  • TRANSLATE : replaces values in a string from a source to a target set 
  • TRIM / LTRIM / RTRIM : removes whitespace characters at the start, the end or both 
  • UNICODE / NCHAR : Returns the integer value, as defined by the Unicode standard, of a character, and the other way around 

We intend to continue adding new functions to the language, more to come soon. 

 

MIN/MAX now supports NVARCHAR(MAX) 

Up until now, the MIN and MAX aggregate functions could only be applied on columns of data types BIGINT, DATETIME and FLOAT. These two functions have been extended to support BIT and NVARCHAR(MAX) expressions as argument.  

 

In order not to break the previous behavior (implicit casting to FLOAT), only columns that have been explicitly typed in NVARCHAR(MAX) will be accepted as argument: 

 

SELECT  
    TollId,  
    System.Timestamp() AS WindowEnd,  
    MAX(CAST(LicensePlate AS NVARCHAR(MAX)) as MaxLicensePlate  
FROM entry 
GROUP BY TollId, TumblingWindow(hour,1) 

 

 

New bitwise operators for bits

With compatibility level 1.2 we started supporting bit as a native type. We are now adding the associated bitwise operators& (bitwise AND), | (bitwise OR), ^ (bitwise exclusive OR) and ~ (bitwise NOT).  

 

A bitwise operator performs a bitwise logical operation between the two expressions, taking each corresponding bit for both expressions. For bitwise AND, the bits in the result are set to 1 if and only if both bits (for the current bit being resolved) in the input expressions have a value of 1; otherwise, the bit in the result is set to 0: 

 

170 & 75 = 10 
170 : 0000 0000 1010 1010 
 75 : 0000 0000 0100 1011  
-------------------------
 10 : 0000 0000 0000 1010 

 

These operators perform bitwise operations on BIT and BIGINT values. Float values will be implicitly (or explicitly with CAST/TRY_CAST) converted with the following rules: 

 

From 

To 

BIT 1 

FLOAT 1.0 

BIT 0 

FLOAT 0.0 

BIT NULL 

FLOAT NULL 

FLOAT 0.0 

BIT 0 

FLOAT any other value 

BIT 1 

FLOAT NULL 

BIT NULL 

 

Get started now!

All of these new features have already been released and can be used in your jobs! If you haven't yet created a job, a good place to start with Azure Stream Analytics is to use one of the quick starts from our documentation page.

%3CLINGO-SUB%20id%3D%22lingo-sub-2902284%22%20slang%3D%22en-US%22%3EIgnite%202021%20-%20Azure%20Stream%20Analytics%20SQL%20improvements%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2902284%22%20slang%3D%22en-US%22%3E%3CH2%20id%3D%22toc-hId--299867739%22%20id%3D%22toc-hId--299717109%22%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3ENew%20built-in%20functions%20and%20improvements%20for%26nbsp%3BAzure%20Stream%20Analytics%26nbsp%3BSQL%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20article%20will%20focus%20on%20the%20most%20recent%20updates%20on%20ASA%20for%20the%20query%20language.%20The%20rest%20of%20the%20announcements%20can%20be%20found%20on%20the%20%3CA%20title%3D%22Analytics%20on%20Azure%20blog%20%3A%20ASA%20announcements%20for%20Ignite%20Fall%202021%22%20href%3D%22https%3A%2F%2Faka.ms%2FASAIgnite2021%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Emain%20Ignite%20Fall%202021%20post%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EAzure%20Stream%20Analytics%20is%20a%20fully%20managed%20streaming%20engine%20with%20user-friendly%20user-interface%20and%20a%20simple%20SQL%20language.%20If%20our%20language%20is%20already%20very%20close%20to%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3BT-SQL%2C%20the%20flavor%20of%20SQL%20used%20in%20SQL%20Server%20and%20Azure%20SQL%2C%20we%20are%20working%20on%20closing%20the%20gap%20completely.%20To%20that%20goal%2C%20we%20are%20extending%20existing%20functions%2C%20and%20adding%20new%20ones%2C%20that%20will%20simplify%20queries%20for%20the%20most%20common%20tasks%20and%20bring%20stream%20and%20batch%20closer%20together.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EIf%26nbsp%3Ball%26nbsp%3Bthese%20capabilities%20were%20already%20available%20in%20Stream%20Analytics%20via%20User%20Defined%20Functions%2C%20having%20them%20supported%20by%20built-in%20functions%20reduce%20query%20complexity%2C%26nbsp%3Bimprove%20performance%2C%20and%20eventually%26nbsp%3Bwill%26nbsp%3Bmake%26nbsp%3Bqueries%26nbsp%3Bmore%20easily%20portable%20to%20T-SQL.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-390693735%22%20id%3D%22toc-hId-390844365%22%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3ENew%20built-in%20functions%3A%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FH3%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EEach%20function%20is%20documented%20with%20examples%20and%20remarks.%20They%20are%20intended%20to%20function%20as%20closely%20as%20possible%20as%20their%20T-SQL%20counterparts.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22ASA%20New%20SQL%20Functions%20-%20Ignite%202021.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F323918i920D5AEC0B66C985%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22ASA%20New%20SQL%20Functions%20-%20Ignite%202021.png%22%20alt%3D%22ASA%20New%20SQL%20Functions%20-%20Ignite%202021.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%20data-leveltext%3D%22-%22%20data-font%3D%22Calibri%22%20data-listid%3D%221%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%221%22%20data-aria-level%3D%221%22%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20CONCAT_WS%20built-in%20function%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Fconcat-ws-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ECONCAT_WS%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3A%26nbsp%3Breturns%20a%20string%20resulting%20from%20the%20concatenation%20of%20string%20values%20in%20an%20end-to-end%20manner%20with%20a%20separator%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22-%22%20data-font%3D%22Calibri%22%20data-listid%3D%221%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%222%22%20data-aria-level%3D%221%22%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20LEFT%20built-in%20function%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Fleft-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ELEFT%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%2F%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20RIGHT%20built-in%20function%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Fright-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ERIGHT%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3A%20returns%20the%20left%20or%20right%20part%20of%20a%20string%20with%20the%20specified%20number%20of%20characters%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22-%22%20data-font%3D%22Calibri%22%20data-listid%3D%221%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20NULLIF%20built-in%20function%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Fnullif-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ENULLIF%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3A%20returns%20a%20null%20value%20if%20the%20two%20specified%20expressions%20are%20equal%2C%20the%20first%20if%20not%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22-%22%20data-font%3D%22Calibri%22%20data-listid%3D%221%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20REPLICATE%20built-in%20function%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Freplicate-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EREPLICATE%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3A%26nbsp%3Brepeats%20a%20string%20value%20a%20specified%20number%20of%20times%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22-%22%20data-font%3D%22Calibri%22%20data-listid%3D%221%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20REVERSE%20built-in%20function%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Freverse-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EREVERSE%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3A%26nbsp%3Breturns%20the%20reverse%20order%20of%20a%20string%20value%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22-%22%20data-font%3D%22Calibri%22%20data-listid%3D%221%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20SPACE%20built-in%20function%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Fspace-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ESPACE%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3A%26nbsp%3Breturns%20a%20string%20of%20repeated%20spaces%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22-%22%20data-font%3D%22Calibri%22%20data-listid%3D%221%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20STUFF%20built-in%20function%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Fstuff-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ESTUFF%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3A%26nbsp%3Binserts%20a%20string%20into%20another%20string%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22-%22%20data-font%3D%22Calibri%22%20data-listid%3D%221%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20TRANSLATE%20built-in%20function%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Ftranslate-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ETRANSLATE%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3A%26nbsp%3Breplaces%20values%20in%20a%20string%20from%20a%20source%20to%20a%20target%20set%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22-%22%20data-font%3D%22Calibri%22%20data-listid%3D%221%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20TRIM%20built-in%20function%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Ftrim-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ETRIM%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%2F%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20LTRIM%20built-in%20function%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Fltrim-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ELTRIM%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%2F%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20RTRIM%20built-in%20function%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Frtrim-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ERTRIM%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3A%20removes%20whitespace%20characters%20at%20the%20start%2C%20the%20end%20or%20both%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22-%22%20data-font%3D%22Calibri%22%20data-listid%3D%221%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20UNICODE%20built-in%20function%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Funicode-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EUNICODE%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%2F%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20NCHAR%20built-in%20function%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Fnchar-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ENCHAR%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3A%26nbsp%3BReturns%20the%20integer%20value%2C%20as%20defined%20by%20the%20Unicode%20standard%2C%20of%20a%20character%2C%20and%20the%20other%20way%20around%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EWe%20intend%20to%20continue%20adding%20new%20functions%20to%20the%20language%2C%20more%20to%20come%20soon.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId--1416760728%22%20id%3D%22toc-hId--1416610098%22%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3EMIN%2FMAX%26nbsp%3Bnow%20supports%20NVARCHAR(MAX)%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FH3%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EUp%20until%20now%2C%20the%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20MIN%20built-in%20function%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Fmin-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EMIN%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3Band%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20MAX%20built-in%20function%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Fmax-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EMAX%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3Baggregate%20functions%20could%20only%20be%20applied%20on%26nbsp%3Bcolumns%20of%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20Data%20types%20in%20ASA%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Fdata-types-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Edata%20types%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3BBIGINT%2C%20DATETIME%20and%26nbsp%3BFLOAT.%26nbsp%3BThese%26nbsp%3Btwo%26nbsp%3Bfunctions%26nbsp%3Bhave%20been%20extended%20to%20support%20BIT%20and%20NVARCHAR(MAX)%20expressions%20as%20argument.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EIn%20order%20not%20to%20break%20the%26nbsp%3Bprevious%26nbsp%3Bbehavior%26nbsp%3B(implicit%20casting%20to%20FLOAT)%2C%20only%20columns%26nbsp%3Bthat%20have%20been%26nbsp%3Bexplicitly%20typed%20in%26nbsp%3BNVARCHAR(MAX)%26nbsp%3Bwill%20be%20accepted%26nbsp%3Bas%20argument%3A%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-sql%22%3E%3CCODE%3ESELECT%20%20%0A%20%20%20%20TollId%2C%20%20%0A%20%20%20%20System.Timestamp()%20AS%20WindowEnd%2C%20%20%0A%20%20%20%20MAX(CAST(LicensePlate%20AS%20NVARCHAR(MAX))%20as%20MaxLicensePlate%20%20%0AFROM%20entry%20%0AGROUP%20BY%20TollId%2C%20TumblingWindow(hour%2C1)%20%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-1070752105%22%20id%3D%22toc-hId-1070902735%22%3E%26nbsp%3B%3C%2FH3%3E%0A%3CH3%20id%3D%22toc-hId--736702358%22%20id%3D%22toc-hId--736551728%22%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3ENew%20bitwise%20operators%20for%20bits%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EWith%20compatibility%20level%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20Compatibility%20Levels%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstream-analytics%2Fstream-analytics-compatibility-level%23compatibility-level-12%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3E1.2%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3Bwe%20started%20supporting%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20Data%20types%20in%20ASA%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Fdata-types-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Ebit%20as%20a%20native%20type%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E.%20We%20are%20now%20adding%20the%20associated%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20Bitwise%20operators%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Fbitwise-operators-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Ebitwise%20operators%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%3A%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20Bitwise%20AND%20operator%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Fbitwise-and-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26amp%3B%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B(bitwise%20AND)%2C%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20Bitwise%20OR%20operator%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Fbitwise-or-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3E%7C%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B(bitwise%20OR)%2C%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20Bitwise%20XOR%20operator%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Fbitwise-xor-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3E%5E%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B(bitwise%20exclusive%20OR)%20and%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20-%20Bitwise%20NOT%20operator%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fstream-analytics-query%2Fbitwise-not-azure-stream-analytics%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3E~%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B(bitwise%20NOT).%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EA%20bitwise%20operator%20performs%20a%20bitwise%20logical%20operation%20between%20the%20two%20expressions%2C%20taking%20each%20corresponding%20bit%20for%20both%20expressions.%20For%20bitwise%20AND%2C%20the%20bits%20in%20the%20result%20are%20set%20to%201%20if%20and%20only%20if%20both%20bits%20(for%20the%20current%20bit%20being%20resolved)%20in%20the%20input%20expressions%20have%20a%20value%20of%201%3B%20otherwise%2C%20the%20bit%20in%20the%20result%20is%20set%20to%200%3A%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-sql%22%3E%3CCODE%3E170%20%26amp%3B%2075%20%3D%2010%20%0A170%20%3A%200000%200000%201010%201010%20%0A%2075%20%3A%200000%200000%200100%201011%20%20%0A-------------------------%0A%2010%20%3A%200000%200000%200000%201010%20%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EThese%20operators%20perform%20bitwise%20operations%20on%26nbsp%3BBIT%26nbsp%3Band%26nbsp%3BBIGINT%26nbsp%3Bvalues.%26nbsp%3BFloat%20values%20will%20be%26nbsp%3Bimplicitly%26nbsp%3B(or%26nbsp%3Bexplicitly%26nbsp%3Bwith%20CAST%2FTRY_CAST)%20converted%20with%20the%20following%20rules%3A%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CTABLE%20data-tablestyle%3D%22MsoTable15List4Accent1%22%20data-tablelook%3D%221696%22%20aria-rowcount%3D%227%22%3E%0A%3CTBODY%3E%0A%3CTR%20aria-rowindex%3D%221%22%3E%0A%3CTD%20width%3D%22183.625px%22%20height%3D%2230px%22%20data-celllook%3D%224353%22%3E%3CP%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3EFrom%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%22102px%22%20height%3D%2230px%22%20data-celllook%3D%22273%22%3E%3CP%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3ETo%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%20aria-rowindex%3D%222%22%3E%0A%3CTD%20width%3D%22183.625px%22%20height%3D%2230px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EBIT%201%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%22102px%22%20height%3D%2230px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EFLOAT%201.0%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%20aria-rowindex%3D%223%22%3E%0A%3CTD%20width%3D%22183.625px%22%20height%3D%2230px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EBIT%200%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%22102px%22%20height%3D%2230px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EFLOAT%200.0%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%20aria-rowindex%3D%224%22%3E%0A%3CTD%20width%3D%22183.625px%22%20height%3D%2230px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EBIT%20NULL%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%22102px%22%20height%3D%2230px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EFLOAT%20NULL%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%20aria-rowindex%3D%225%22%3E%0A%3CTD%20width%3D%22183.625px%22%20height%3D%2230px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EFLOAT%200.0%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%22102px%22%20height%3D%2230px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EBIT%200%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%20aria-rowindex%3D%226%22%3E%0A%3CTD%20width%3D%22183.625px%22%20height%3D%2230px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3EFLOAT%20any%20other%20value%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%22102px%22%20height%3D%2230px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EBIT%201%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%20aria-rowindex%3D%227%22%3E%0A%3CTD%20width%3D%22183.625px%22%20height%3D%2231px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EFLOAT%20NULL%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%22102px%22%20height%3D%2231px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EBIT%20NULL%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3C%2FTBODY%3E%0A%3C%2FTABLE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-1750810475%22%20id%3D%22toc-hId-1750961105%22%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3EGet%20started%20now!%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FH3%3E%0A%3CP%3EAll%20of%20these%20new%20features%20have%20already%20been%20released%20and%20can%20be%20used%20in%20your%20jobs!%20If%20you%20haven't%20yet%20created%20a%20job%2C%20a%20good%20place%20to%20start%20with%20Azure%20Stream%20Analytics%20is%20to%20use%20one%20of%20the%20quick%20starts%20from%20our%20%3CA%20title%3D%22Azure%20Stream%20Analytics%20-%20Doc%20%3A%20Visual%20Studio%20Code%20quick%20start%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstream-analytics%2Fquick-create-visual-studio-code%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Edocumentation%20page%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2902284%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EAs%20we%20continue%20to%20bring%20the%20Stream%20Analytics%20Query%20Language%20closer%20to%20T-SQL%2C%20this%20Ignite%20we%20are%20extending%20existing%20functions%2C%20and%20adding%20new%20ones%2C%20that%20will%20simplify%20queries%20for%20the%20most%20common%20tasks%20and%20bring%20stream%20and%20batch%20closer%20together.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2902284%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAnalytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20Stream%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Nov 05 2021 03:02 PM
Updated by: