Viewing 15 posts - 286 through 300 (of 832 total)
Brandon Leach (8/20/2012)
I've fallen into this trap many times. I'd find myself logging in to check on things on days off, etc.
I do that too, but it's usually just...
August 20, 2012 at 7:21 am
Guessing the people who answered that both would return 10 really didn't read the question very well...
August 20, 2012 at 1:26 am
Sometimes things can go a bit far the other way--because I wasn't able to take 8 days of holiday last year (gave it up voluntarily due to things being so...
August 20, 2012 at 1:24 am
Hugo Kornelis (8/4/2012)why would anyone put comments in dynamic SQL? They should go in the non-dynamic part of the SQL, where the dynamic SQL is built.
I'm guessing the question setter...
August 6, 2012 at 1:12 am
justin_heilbron (8/2/2012)
Hi GuysThank you for the replies. I need to recreate the error as we had to remove the added column in order to continue production.
So...you don't have a test...
August 3, 2012 at 3:19 am
Carlo Romagnano (8/3/2012)
Try this one code you'll be surprised:
DECLARE @STR1 VARCHAR(45)SET @STR1 = 'select * from #tmpTable --/*' + char(13) + 'where Fld1 = 0--*/'
print len(@STR1)
All you've proved there is...
August 3, 2012 at 2:31 am
I'm a bit baffled as to why the author chose 45 characters as the string length when the fourth one is longer than that...I actually wasn't sure what the result...
August 3, 2012 at 2:03 am
I didn't know about the selectable precision in datetime2, but once I read up about it, it became fairly clear what the answer should be--the only thing I was unsure...
August 2, 2012 at 8:54 am
GSquared (7/20/2012)
Gets even worse when you realize that billion, trillion, et al, mean different things in the US and the UK.
Not so much anymore...the BBC news always uses billion etc....
July 20, 2012 at 9:28 am
Sounds utterly ridiculous. Yes, you need to identify the severely underperforming people and either fire them or move them to a different job more suited to their talents, but in...
July 20, 2012 at 1:52 am
Steve Jones - SSC Editor (7/19/2012)
I'll trade you this for making everyone drive on the right side of the road :w00t:
But if we did that, how would we keep our...
July 20, 2012 at 1:34 am
BenWard (7/19/2012)
we can track how fast they drive vs speed limit on the roads they are on and the g-forces caused by their cornering and acceleration to see if they...
July 19, 2012 at 9:03 am
I'm pretty sure that farmers themselves don't give half a monkey's for DST--they structure their day around the rising and setting of the sun, and what direction the hour hand...
July 19, 2012 at 8:46 am
Mad Myche (7/18/2012)
Daylight Savings time was a scheme created for the eco-nuts to lower lighting bills and HVAC costs.
Really? I'm surprised there were so many eco-nuts around in 1916, or...
July 19, 2012 at 7:20 am
Thomas Abraham (7/17/2012)It's easier to sell some new doodad than say that last's year's doodad is improved.
Surely adding the timezone feature mentioned by Steve would count as a "new doodad"...
July 17, 2012 at 5:44 am
Viewing 15 posts - 286 through 300 (of 832 total)