Personally, I like the Instead of Trigger, unless you are willing to alter the schema to a new setup. The reason is this. There's no reason to through any error....

I'm not quite sure what you are trying to accomplish here. I assume this is some formatting of the data all on one line. Is that correct?

Can...

Indexing would be preferred over the constraint, especially if you might get lots of inserts occurring in a short period of time. I'd go with Thom's solution.

If you...

Apologies on the answer. My scheduling thing didn't quite work as expected.

Answer here: http://www.sqlservercentral.com/articles/Logic+Puzzle/176523/

Yes, apologies. The code and repl had sample.py, but I edited the name in the question to make it sound better.

Corrected

It's definitely a thorny issue to use stats in sports. The thing many people want in sports is some guarantee. This doesn't do that. You can't predict a score, but...

FWIW: https://sqldusty.com/2018/08/21/nfl-football-player-stats-analysis-2018-is-now-available/

The answer I got it that there are a number of features from that security tab that write to the registry, which doesn't exist on Windows.  I think the Windows...

I think this is partially an explanation and partially an argument for why.

In that sense, reasonable people can make some decision in judgment of how to view the...