Forum Replies Created

Viewing 15 posts - 601 through 615 (of 769 total)

  • RE: Is there a Bug with the Replace() Function in SQL Server 2005

    Jeff Moden (12/26/2008)


    Yep... we all agree on that. I believe the main complaint is... the documentation doesn't say anything about the default size.

    THANK YOU Jeff!

    I was starting to...

  • RE: A Dearth of Comments

    Documentation is like an intimate encounter:

    1) Not everyone is at the same level of knowledge or expertise

    2) The way you prefer it may not be the way others do

    3)...

  • RE: Complete Blocking Report

    Is anyone else having problems getting to the page with the actual script/code? No matter how I try to navigate to it, everytime I get the 'Need to Register'...

  • RE: A Dearth of Comments

    Steve Jones - Editor (1/5/2009)


    Are you complaining about BOL? It's definitely lacking in places, but it's a pretty good document and I love the ability to give back feedback or...

  • RE: A Dearth of Comments

    Somone may have alrady mentioned this as I have not reaed thru all 3 pages of comments (not enough time this morning) but I feel its important to add a...

  • RE: A Dearth of Comments

    Timothy (1/5/2009)


    I'll admit I rarely write comments. About the only time I do is if the code has "gotchas": basically it does things in a way you wouldn't normally expect...

  • RE: Is there a Bug with the Replace() Function in SQL Server 2005

    Jeffrey Williams (12/18/2008)


    So, once again I will ask the question. Given:

    SELECT REPLACE('abcdefghijklmno', 'mno', 'abc');

    What is the expected datatype of the output? VARCHAR - as defined in BOL.

    What is...

  • RE: Is there a Bug with the Replace() Function in SQL Server 2005

    Lynn Pettis (12/18/2008)


    You are comparing apples to oranges when comparing the action of REPLACE with UPPER. REPLACE doesn't know how big the returned string is going to be when...

  • RE: Smart Teaching

    Steve Jones - Editor (12/24/2008)


    The US has a few things going against it. Culturally I think we've hit a tipping point where parents are too successful and it causes lots...

  • RE: Smart Teaching

    Computers as well as Technology in general should help us doing things faster and/or more easily that we already know how to do without the technology. There are of...

  • RE: The Best Computer

    cyplesma (12/19/2008)


    YSLGuru (12/19/2008)


    The systems in the Iron Man Movie & the latest Bond film (as well as the desktop used by the administartor character in the movie The Island from...

  • RE: The Best Computer

    blandry (12/19/2008)


    (First - a correction for AndyD... Holly is NOT the female computer in Red Dwarf - that is Hilly. Holly is the actor Norman Lovett, a male...

  • RE: The Best Computer

    The systems in the Iron Man Movie & the latest Bond film (as well as the desktop used by the administartor character in the movie The Island from about 3...

  • RE: Is there a Bug with the Replace() Function in SQL Server 2005

    Jeffrey Williams (12/17/2008)


    I understand where you are seeing this as a problem. What I was trying to show you is that this is not a problem, but instead your...

  • RE: Is there a Bug with the Replace() Function in SQL Server 2005

    ALZDBA (12/16/2008)


    it is not a bug,

    it is a limit one must know about.

    If you need more than 8000 bytes, you need an implicit convert to varchar(max).

    ,replace(cast('abcdefghicde' as varchar(max)) ,'cde' ,'xxx')...

Viewing 15 posts - 601 through 615 (of 769 total)