The View Insert

Question

The View Insert

Viewing 4 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 738632 More actions · Answer 1

Fair enough, Tom, but I think it makes perfect sense the way MS has defined this and it works. The view references 6 columns in one table, and since they allow NULL by default, this makes sense and adheres to the definitions of the product.

Revenant SSC-Forever Points: 42467 More actions · Answer 2

TomThomson (7/14/2016)
Steve Jones - SSC Editor (7/14/2016)
You are all welcome, and glad I got a good one here. This was something I learned as well.
Actually, I think you got a terrible one here. . . .
What we actually have here is that MS SQL is executing an update statement that alter some data, but doesn't actually update what it says it will update, and doesn't signal an error despite not achieveing the update requested and it being clearly documented by microsoft ; if you [Steve] want to treat that as "it works fine" then fair enough: that's your idea of what's fine, but it's certainly not mine.

Tom, why don't you file a bug? If you for whatever reason do not want to do that, I might take on that.

Stephanie Giovannini SSCertifiable Points: 7422 More actions · Answer 3

This QOTD should have a disclaimer:

This schema blatantly violates second normal form and is presented for demonstration purposes only. Do not use this schema as part of class-scheduling system. No actual databases were mangled in the production of this question.

(Was that bothering anyone else?)

SQLRNNR SSC Guru Points: 281344 More actions · Answer 4

Stephanie Giovannini (7/15/2016)
This QOTD should have a disclaimer:
This schema blatantly violates second normal form and is presented for demonstration purposes only. Do not use this schema as part of class-scheduling system. No actual databases were mangled in the production of this question.
(Was that bothering anyone else?)

Nope. It seemed pretty clear it was an example for the purpose of the question. Additionally, it is far from the terrible stuff i see in the wild as a consultant. It really is probably about 10x better design than most things I see out there.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events