Thanks, and no horse chores for me. A little under the weather yesterday, but luckily my kids stepped up and shouldered the load

Happy Holidays and Merry Christmas, everyone. Enjoy the long weekend.

I've used AI mostly for things outside of SQL development.  Like git and C# and Powershell.  It seems like it saves time (not always tho) and I go to...

It was a weird thing I stumbled on when working with arrays and removing elements as dale_berta noted, the array is still the same size, which is expected. It shouldn't...

Hope you enjoy it. I've gone through 16 days so far, and I have some catching up to do after a busy week. I'll likely dig in this afternoon for...

Your opinion is wrong. The question asks for defaults for this T-SQL code. The defaults are not stored in sys.parameters. They are only in the code definition in sys.sql_modules.definition.

 

The state department I work for has blocked all generative AI. I don't know why. It might even be blocked for all state departments. I don't have access to...

It's crazy these aren't parsed and maintained in a DMV for T-SQL procs, but they're not

The docs note this has default values for SQLCLR procs, not T-SQL ones.

SQL 2019:

 

SQL 2022

December 21, 2023 at 5:18 pm

#4350333

Thanks, fixed

Yeah, the parsing for the code formatting is that there are so many cases with the regex and replacement that I think we're fixing one thing but breaking another.

Bug filed...

I'll log a bug. I hope this is an easy fix.

We that's interesting.

OK, sorry, moving too fast this am. I missed that.

Test 2, space for table 1

SELECT [T1].* -- or could do [T2].*, not certain which table row you...

I think the formatting can be weird, but not seeing the issue.

Do you have a screenshot of what's broken/weird on your side? I'm chrome, 119.0.6045.200