Viewing 15 posts - 1 through 15 (of 17 total)
I have it in my head that the exists (select * …) construct is adherent to the ANSI standards. I don't have a source on that unfortunately.
April 25, 2017 at 6:46 pm
I use [font="Courier New"]sql_variant_property()[/font] when analysing literals, but you have to use it three times to get all the information you need about decimal and numeric types (assuming you're making...
October 3, 2016 at 2:09 am
g.britton (6/10/2016)
FWIW I grabbed the underscore idea from years of programming in Python. It's the typical "throwaway" identifier. Almost, but not quite, anonymous. (like "@" in SQL)
Ah yes,...
June 10, 2016 at 12:29 pm
g.britton (6/10/2016)
June 10, 2016 at 11:59 am
ronmoses (4/2/2015)
INCREDIBLEmouse (4/2/2015)
Why not, cross apply (something) as SomethingDescriptiveButNotThisLong
I also prefer at least semi-descriptive table aliases, just to help me keep track of where different values are coming from. So...
June 10, 2016 at 11:06 am
drew.allen (6/9/2016)
This suffers the same exact problem that I mentioned here http://www.sqlservercentral.com/Forums/FindPost1792490.aspx
Ohhh, I do apologise. I didn't click that he was assigning any semantic significance to the 1900 date; I...
June 9, 2016 at 9:29 am
RAThor (6/9/2016)
You are correct about the short ISO format (yyyyMMdd). But unfortunately the ODBC canonical format 'yyyy-MM-dd' can still be ambiguous.
Ah yes, DATEFORMAT. Though I don't think any languages use...
June 9, 2016 at 9:19 am
a) both the things DouglasH said
b) you mentioned they were heaps and now have indexes; but do they now have clustered indexes? If not then they're still heaps. This may...
June 8, 2016 at 10:39 pm
My immediate thought was "it depends entirely on what parameter you pass the second time you execute it". Maybe I'm a bit jaded and constantly seeking trickery 🙂
My second thought...
May 9, 2016 at 7:40 pm
I actually assumed that the constraint would be fine, but untrusted. And thus just learnt that new constraints issue a check upon creation.
May 29, 2015 at 5:20 pm
Alan.B (5/29/2015)
Take a look at this link: What is the fastest way to calculate the median? Note the comments and links posted by Dwain Camps. Interesting stuff.
That's actually the same...
May 29, 2015 at 4:56 pm
Did a little bit earlier this week. We'd encountered an issue in which certain orders got stuck in a "paying" state. This state applies when a customer has opened a...
May 29, 2015 at 7:25 am
abatej (4/7/2015)
On the whole...
I actually tried to duplicate the example on one of my oracle instances. I had to rework the update to use a sub-select because it wouldn't...
April 7, 2015 at 8:59 am
abatej (4/6/2015)
April 7, 2015 at 7:36 am
Viewing 15 posts - 1 through 15 (of 17 total)