Forum Replies Created

Viewing 15 posts - 1,891 through 1,905 (of 7,636 total)

  • RE: Are the posted questions getting worse?

    Matt Miller (7/13/2009)

    Jeff Moden (7/13/2009)

    Dave Ballantyne (7/13/2009)

    You can lead a horse to water but you cant force him to drink

    Heh... well... you can if you don't mind getting your lips...

    July 13, 2009 at 9:43 am

    #1023986

  • RE: CLR TVF-: how can we send the optinal parameter

    Florian Reischl (7/13/2009)

    RBarryYoung (7/12/2009)

    Paul White (7/12/2009)

    RBarryYoung (7/12/2009)

    Now back in the old VB, you could specify optional parameters without having to also specify a default (in fact originally you couldn't specify...

    July 13, 2009 at 7:29 am

    #1023868

  • RE: Self-Referencing Table with Composite Primary Key?

    To the best of my recollection, you canNOT normally create FK constraints for self-referencing relations, because sometimes the ParentID has to be NULL which cannot effectively be handled by FK...

    July 13, 2009 at 7:02 am

    #1023844

  • RE: how to stop runaway proc

    Martin Walter (7/12/2009)

    Barry,

    I couldn't drop the queue because it was bound to the service.

    Yep, that's why you have to drop the service first.

    I dropped the service but it seemed to...

    July 13, 2009 at 6:44 am

    #1023829

  • RE: CLR TVF-: how can we send the optinal parameter

    Paul White (7/12/2009)

    RBarryYoung (7/12/2009)

    Now back in the old VB, you could specify optional parameters without having to also specify a default (in fact originally you couldn't specify defaults at all)....

    July 12, 2009 at 5:22 pm

    #1023657

  • RE: Login

    As for the first thing, make sure that Steve Jones is aware of this.

    For the second: You username and password only work for the newsletter links that ultimately end up...

    July 12, 2009 at 4:28 pm

    #1023655

  • RE: CLR TVF-: how can we send the optinal parameter

    back to the original question...

    Although both T-SQL and VB.net support optional parameters (in a virtually identical form), it does not appear to me that SQLCLR supports them. Though you...

    July 12, 2009 at 4:22 pm

    #1023653

  • RE: CLR TVF-: how can we send the optinal parameter

    Paul White (7/9/2009)

    Florian Reischl (7/9/2009)

    Nope. I meant optional parameters with default values like often done in C++ or VB6 (don't know if VB.NET supports this feature any more). The "params"...

    July 12, 2009 at 4:17 pm

    #1023652

  • RE: CLR TVF-: how can we send the optinal parameter

    Florian Reischl (7/9/2009)

    ...

    Nope. I meant optional parameters with default values like often done in C++ or VB6 (don't know if VB.NET supports this feature any more)...

    Oh it definitely does....

    July 12, 2009 at 4:12 pm

    #1023650

  • RE: how to stop runaway proc

    Dropping a service should always be possible (though possibly there might be a way to lock it up with schemabinding, not sure if that applies to SB services).

    DROPPING the queue...

    July 11, 2009 at 9:04 am

    #1023506

  • RE: Add column at ordinal position programmatically

    Lowell, are you going to update your posted script here at SSC? I point people from other sites to it all the time.

    July 11, 2009 at 8:54 am

    #1023502

  • RE: Add column at ordinal position programmatically

    I just reviewed the latest version Lowell, and it's freakin' awesome. I can't believe how much work you must have put into this.

    July 11, 2009 at 8:47 am

    #1023499

  • RE: Add column at ordinal position programmatically

    RBarryYoung (7/5/2009)

    Some aspects of this a relatively easy. But other aspects are really hard. And the hardest part is being sure that you haven't actually missed anything because...

    July 11, 2009 at 8:42 am

    #1023497

  • RE: Are the posted questions getting worse?

    RBarryYoung (7/10/2009)

    Gaby Abed (7/9/2009)

    ...

    There is a term for lovers of the long word: Sesquipedalian

    Is it a hobby or a condition? 😀

    Condition, definitely. Not quite as sure what condition, but...

    July 11, 2009 at 8:36 am

    #1023494

  • RE: Are the posted questions getting worse?

    Bruce W Cassidy (7/9/2009)

    Paul White (7/9/2009)

    Ah - so you are a fan of anti-verbositization then :w00t:

    [font="Verdana"]If only mere words could express my floccinaucinihilipilification of verbiage...[/font]

    Yeah, I have the same problem....

    July 10, 2009 at 11:38 pm

    #1023455

Viewing 15 posts - 1,891 through 1,905 (of 7,636 total)