T-SQL executing directly in Eventhouse KQL Queryset without comment (--) prefix

[Ruchi23]

Hey everyone,

I was just exploring Eventhouse and noticed something weird. The docs say you need to add "--" on its own line before T-SQL queries in KQL querysets, but I'm running T-SQL commands just fine without it.

I never added the "--" prefix and all T-SQL queries executed normally.

Is this a recent change? The documentation still mentions needing the comment prefix to switch to T-SQL mode, but it seems like the query editor is just auto-detecting it now?
Reference: https://learn.microsoft.com/en-us/kusto/query/t-sql?view=microsoft-fabric

[svelde]

Hello @Ruchi23 

Microsoft documentation is open sources and they accept pull requests.

If you have GitHub account, you can change the page yourself here and provide the change as pull request.

If the change is accepted by the official author, this change will make you an official contributor to Microsoft documentation.

[svelde]

Hello @Ruchi23,

Welcome to this community forum.

Good catch, I also experience that my SQL queries work will without the '--' on a separate in from of the query, when I use the Fabric portal KQL Queryset editor.

That said, it can be that other editors for eg. Azure Data Explorer or Microsoft Sentinel still need that extra line. I'm not able to test this.

--

If this answer helps, please upvote it. Thanks.

[Ruchi23]

Thanks for confirming!
I actually tested this on Azure Data Explorer as well and got the same result, T-SQL queries work there too without the "--" prefix.

Looks like the query editors are just smart enough to figure it out now. I wonder if the docs are just outdated at this point or if there's some specific case where you still need it that we just haven't run into yet.