Master.dbo.SysColumns

Question

Master.dbo.SysColumns

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

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

9423t8 Mr or Mrs. 500 Points: 507 More actions · Answer 1

Jeff: Thanks for the link(s). Still can't get my head around that "From TableA, TableB" syntax :sick:, so I'm afraid the other articles you linked to are near-impossible to follow (ditto for the string-splitting one, and for the same reason); though I do appreciate you pointing me to them.

I guess my brain is just 100% allergic to putting a comma between two table names in a FROM clause. >sigh<

BTW "surely" you can only refer to a cross join as a "square join" if the row count of both tables is the same? 😀

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

cad.delworth (4/12/2016)
I guess my brain is just 100% allergic to putting a comma between two table names in a FROM clause. >sigh<

Then take any such occurrence and replace the , with ' CROSS JOIN', because that's all it is.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

9423t8 Mr or Mrs. 500 Points: 507 More actions · Answer 3

Thanks for your suggestion, but without printing out the articles and writing the replacement text on them — or some similar method — my brain can't do that.

In the same way, if someone reads out a number (especially phone numbers) using the words "double" or "treble" along the way, I literally can't understand it: I have to ask the person to read it out a second time, reading each digit out, even if it's the same as either of its neighbours.

I suppose it would be a dull world if we were all the same (although data would be MUCH more ordered and manageable, I guess?!).

Jeff Moden SSC Guru Points: 1003871 More actions · Answer 4

cad.delworth (4/12/2016)
Jeff: Thanks for the link(s). Still can't get my head around that "From TableA, TableB" syntax :sick:, so I'm afraid the other articles you linked to are near-impossible to follow (ditto for the string-splitting one, and for the same reason); though I do appreciate you pointing me to them.
I guess my brain is just 100% allergic to putting a comma between two table names in a FROM clause. >sigh<
BTW "surely" you can only refer to a cross join as a "square join" if the row count of both tables is the same? 😀

I agree that two tables of difference sizes would result in a "rectangle" but I've never heard of anyone citing a "rectangular" join.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)