Interesting question.

As an R novice, it's extremely difficult to deduce from the referenced documentation that COUNT can do this. None of the (rather terse) examples outline this simple use.

Great question (albeit a tad nefarious!)

And this is precisely why both semi-colons and AS for aliases should always be used!

Well, I managed to guess how the author arrived at what was designated as the correct answer. But clearly, that is a gross misunderstanding of the cited article from BOL.

A bit iffy, this one. Change tracking cannot be enabled on a database that contains In-Memory OLTP objects. And CDC is only available from CU15 and up.

Read the question, and thought: I'm not going to touch this with a ten-foot pole, until it has been reviewed. The discussion bears this out...

On a side note: It used...

Sorry for [semi]colon 🙂

It's all right for error, because GO is a batch separator: @x is declared in the first batch and not in the second. It's the same...

Except that's a colon, not a semi-colon...

Confirmed. I went ahead and tried the same as you. In SSMS you get...

• This reply was modified 5 years, 6 months ago by Rune Bivrin.

I get an error when I use !!GO:

'Go' is not recognized as an internal or external command,
operable program or batch file.

But i can use:

            
March 13, 2020 at 3:13 pm
            
#3734093

            
            
                                                
        

DOH!

I read that article right up to the line preceeding the one with the pertinent information.

Now I must finish my coffee!

Good question! Can we expect one for proper next? 🙂

I've been using a related technique to emulate STRING_AGG, so it wasn't that...

Interesting, but I'd be wary of using it. In a multi-row update, the result is pretty much undefined, unless all the rows are updated to the same value. And in...

Yeah, using temp tables is absolutely a workable solution, as is session context. CLR functions probably not, unless they utilize some external...

I doubt that using PRINT to return information is used on a regular basis.  The only time I use PRINT for the purpose is for debugging a procedure I...