Many people aren't allowed DBATools. Not sure why, as it's a great resource.

To be fair, the question asked for T-SQL, so shelling out isn't always the right solution.

No, newer features do not work. Most features are backwards compatible, but if the feature didn't exist in 2019, it won't run there.

And speaking of articles........ anything new on your mind? Maybe an opinion piece/editorial?

Those are good hints to use.

The business case is rework. This is time-consuming and expensive. As Jason noted above, if someone uses a feature that isn't in prod, then this doesn't get detected until a...

I'm not completely sure what you're asking here. In terms of setup, I think you have:

1. Dev - SQL 2022 Standard on a VM (vm doesn't matter)
2. Prod - SQL...

I don't believe so. You might be able to force specific entries are set a certain way, but I don't think you can edit an entry, as you're asking.

If these...

I was an apple person and thought they'd rule the world.

You've incorrectly tested this. The question stores data as strings.

try_parse isn't for numerics

Lol. I knew there was an error, but I had to re-test too 😉

do you?

The question was reworded after these comments (first2 ), so they are valid. The original question didn't say run it directly.

Agreed, and my apologies. Reworded the question and awarded points back.

Agreed. It's like capitalism. It's got a ton of problems and issues, but it's better than everything else

It doesn't because this isn't two inserts. It's a TVC (Values) that materializes first, and then when the insert happens, the TVC has already set the data type.