Viewing 15 posts - 1 through 15 (of 117 total)
Interesting.. Didn't even know that this was in T-SQL. I got the answer right because I have programmed in C. Is this just a T-SQL thing or is it standard...
October 27, 2020 at 6:06 am
ssn[7:10] gives you '456'
October 22, 2020 at 5:40 pm
Python is 0 based so ssn is '4'. ssn[7:] is '4567'
October 22, 2020 at 6:24 am
Been involved with this too many times.
Users think Excel can do everything and when it can't they don't comprehend. I've given them a Microsoft Access front end a few times...
October 19, 2020 at 6:09 am
Hadn't got to this in my Python Ed. I can see this being useful.
October 8, 2020 at 6:07 am
That's useful. You get so used to clicking away during installs that you miss something fundamental like the collation. I'm personally happy with the defaults but not all clients are.
August 26, 2020 at 6:19 am
It makes sense but I find business users have trouble with negative numbers in general. We have situations where we've run out of numbers to use for things which could...
May 27, 2020 at 6:32 am
April 1, 2020 at 6:40 am
I fell for it.
April 1, 2020 at 6:01 am
The Syntax looked wrong based on what I knew but then I don't know everything so thought I'm going to learn another Microsoft shortcut. I actually like the incorrect Syntax....
August 5, 2019 at 6:18 am
Altering the Database while it's being backed up is beyond my bravery level.
July 19, 2019 at 6:27 am
Took a Guess on 3 & 4. Couldn't remember whether it was 0 or 1 based.
July 18, 2019 at 8:18 am
Happy belated 4th of July from Auckland. Slowly getting the hang of DateTimeOffsets.
July 17, 2019 at 2:55 am
It doesn't really make sense. Revoke Deny as you suggested would be more intuitive.
I'm having a T-SQL Syntax Issue with the World at the moment. You have to wonder whether...
July 16, 2019 at 8:07 am
Biggest problem that I have with these Windows Functions is that the Concept is straight-forward but the T-SQL Syntax to achieve the desired result is Arcane.
It's almost like the education...
July 16, 2019 at 7:37 am