Forum Replies Created

Viewing 15 posts - 54,736 through 54,750 (of 59,067 total)

  • RE: Limit Resources to UGLY query

    I still don't know what "undocumented behaviour" Noel is talking about...

  • RE: Querying the max row length

    Mahesh Gupta (10/2/2007)


    What exactly do you mean by Max Length of the row ?

    The maximum length of a row can be 8060 bytes. In this case, some of the...

  • RE: Querying the max row length

    Ninja's_RGR'us (10/2/2007)


    When was that?? I never saw it work like I want it to ;)... like the old one.

    Actually, all that stuff worked... for about the first two days...

  • RE: can we modify system tables in SQL Server 2000?

    Heh... already are... hardcore DBA just wouldn't allow this.

  • RE: Querying the max row length

    Lowell (10/2/2007)


    the thing about color is that you MUST enter the double quotes to get it to work.

    input = #0000FF is BAD

    input = "#0000FF" is GOOD

    Heh... thanks Lowell... but I...

  • RE: Remove Decimals Without Rounding

    Yeah, huh? Using loops comes highly unnatural to me. 😀 Goes against my data-troll grain.

    The other place I saw it was with a splitter function that used a...

  • RE: Sproc calling Sproc

    Bill,

    I guess I don't understand why you are calling these procs as passthrough queries from Access... can't you schedule this as a job or run it through OSQL? That...

  • RE: Remove Decimals Without Rounding

    You can touch it. It won't hurt you.

    Heh... and folks think Serqiy is a smartass??? :laugh:

    Anyway, point well taken and I guess I have to eat a little crow on...

  • RE: Querying the max row length

    No... not true...

    1. Editing a post still triple spaces the entire post.

    2. Trying to post with [Code] still results in a triple spaced mess that doesn't obey leading...

  • RE: deduping query optimization

    Perfect... Nice "kick in" Peter... I'm gonna go back to sucking my thumb now... 😛

  • RE: can we modify system tables in SQL Server 2000?

    Heh... I'm old... I've got no "recall" left until I've had about 20 coffees (if I recall correctly) 😀

  • RE: Is this workable

    Tomm Carr (10/2/2007)


    I answered that already. I defined my test table with a nullable datetime field. However, the OP seemed to be using a integer with zero meaning null so...

  • RE: Trigger and deadlocks

    I missed what you're talking about... which movie, Remi?

  • RE: Trigger and deadlocks

    Bingo, Scott... took the words right out of my mouth... don't need the EXE to gen decent XML... it can all be done in T-SQL...

  • RE: Limit Resources to UGLY query

    Just a little warning... you are using an undocumented behaviour and a SP could belly up your project.

    Ummm... what undocumented behaviour?

Viewing 15 posts - 54,736 through 54,750 (of 59,067 total)