First of all, you define some variables and then do an insert and then you break the batch with a GO.  That should mean that when you get to the...

I guess we'll have to agree to disagree on most of that.

Ok, found out what's causing it, but it doesn't make sense to me.

I ran my code on my other machine, which has SSMS v18.4. My code works fine, and...

I cannot speak for others but me being almost permanently RDP'd into the server with an active session of SSMS already up and running has saved our caboose a couple...

To me, most machines/computers/whatever aren't "intelligent" nor are they able to "learn".  At least, not yet.  Don't get me wrong... there's some very, very clever programing being done out there...

In this case, I think that's a bad idea because that may not match the...

I hear you, Steve. There's no one-size-fits-all type of AI. Your analogy of cooking and baking is excellent. I'm a terrible cook, so if I were left on my...

K.  Thanks.  I'll keep looking.  This one has me stumped so far.

Yes. I got to know that Rowcount variable will not be updated until the complete control flow completes.

The sql table have millions of records.Is that the reason it is...

I don't know that we know that it's Social Security Numbers in clear text, do we? We only know that the name of the column is SSN, I think....

In this case, I think that's a bad idea because that may not match the actual number...

In this case, I think that's a bad idea because that may not match the actual number of rows...

• This reply was modified 6 years ago by Jeff Moden.

@DataRat and to all those helping him... please raise your hand if you wouldn't be upset if it was YOUR plain text SSN that was splattered across 35 tables even...

I think that one of the most important parts of all of this can be found in the conclusion section of the article.  In particular, I'm talking about the following...

I'm not talking about the language on Windows... I'm talking about the language settings...