Viewing 15 posts - 44,221 through 44,235 (of 59,063 total)
Sheng (4/7/2009)
Jeff Moden (4/6/2009)
Soooo.... does that mean you're happy now?
...... I can't follow you.:-) I just want to discuss if I've made a right decision about generating this column in...
April 11, 2009 at 12:58 pm
vishal.chawla (4/7/2009)
April 11, 2009 at 12:51 pm
Jim Russell (4/8/2009)
Don't you dare...
April 11, 2009 at 12:28 pm
Lynn Pettis (4/7/2009)
Jeff Moden (4/7/2009)
Only they don't get to come back after calming down.
BWA-HAA!!! That's not a fault... that's a feature. 😛
April 11, 2009 at 12:20 pm
mosaic (4/9/2009)
quick and dirty - but handy for ad-hoc use:Set query output to text
sp_MSforeachtable @command1=" SELECT '?', COUNT(*) FROM ?"
Um... maybe. If you have tables like what are...
April 11, 2009 at 12:11 pm
Sorry... I forgot... here's the code I used for the INT truncation which is the fastest method for truncating a date that I know of.
CREATE FUNCTION dbo.jbmTrunc
--===== Function to...
April 11, 2009 at 11:46 am
andrew gothard (4/11/2009)
April 11, 2009 at 11:41 am
Well... I did it. Thank goodness they extended the deadline of PASS 2009 Session Abstracts. I'll be there one way or another this year.
I saw that...
April 11, 2009 at 11:02 am
GilaMonster (4/11/2009)
Shane Redding (4/11/2009)
In regards to the below, perhaps you should go work for the microsoft sql server team as GOTO is not uncommon in TSQL. 🙂
Just because the...
April 11, 2009 at 10:57 am
GilaMonster (4/11/2009)
Bob Hovious (4/11/2009)
Okay... how many people here advocate the use of GOTO statements in T-SQL?
I do, solely for error handling in SQL 2000. Since there isn't a TRY-CATCH construct...
April 11, 2009 at 10:52 am
steve dassin (4/10/2009)
Jeff Moden (4/10/2009)
steve dassin (4/10/2009)
Do you realize that for over thirty years the relationship between the sqland and relationaland can be categorized by one word - 'Failure'.
Yep......
April 11, 2009 at 1:46 am
Lynn Pettis (4/10/2009)
edit: this one
Oh... that one. It'll probably turn out that they don't have the user login setup on the other machine(s) or, if it is, they...
April 10, 2009 at 7:44 pm
GilaMonster (4/10/2009)
Jeff Moden (4/10/2009)
April 10, 2009 at 7:39 pm
steve dassin (4/10/2009)
Do you realize that for over thirty years the relationship between the sqland and relationaland can be categorized by one word - 'Failure'.
Yep... you've told us many...
April 10, 2009 at 6:59 pm
steve dassin (4/10/2009)[hrThe butcher, the baker and the candlestick maker! You telling me Grimm's Fairy Tales is R rated. I was just being playful. Hey guys lighten up. Think split...
April 10, 2009 at 6:48 pm
Viewing 15 posts - 44,221 through 44,235 (of 59,063 total)