Forum Replies Created

Viewing 15 posts - 46 through 60 (of 143 total)

  • RE: Variable Declaration

    Koen Verbeeck (9/19/2013)


    Very similar to the question a few days ago, but a bit harder.

    Really nice question, thanks.

    Ditto

  • RE: Reserved Words - 1

    mtassin (9/18/2013)


    Stewart "Arturius" Campbell (9/18/2013)


    Good question, Ron, thanks

    Didn't even have to bother executing the T-SQL, which is, after all, what this is all about...

    Yes... yes it is... I too can...

  • RE: Declare Variable

    Hany Helmy (9/15/2013)


    Nice & easy.

    It was only easy for me because there was a question covering the same concept a little while ago.

  • RE: A Hazard of Using the SQL Update Statement

    dwain.c (9/19/2013)


    marlon.seton (9/19/2013)


    dwain.c (9/18/2013)


    marlon.seton (9/18/2013)


    Proiv

    http://www.proiv.com/

    We develop one code set for Windows, Sun & Linux with Oracle, then have to tweak it a bit to for Windows & SQLServer.

    Thanks!...

  • RE: A Hazard of Using the SQL Update Statement

    dwain.c (9/18/2013)


    marlon.seton (9/18/2013)


    Proiv

    http://www.proiv.com/

    We develop one code set for Windows, Sun & Linux with Oracle, then have to tweak it a bit to for Windows & SQLServer.

    Thanks! From...

  • RE: wildcards

    Koen Verbeeck (9/11/2013)


    Vobr Jiri (9/11/2013)


    In SS2k you must use in T-SQL script this version:

    INSERT @i VALUES ('Steve')

    INSERT @i VALUES ('Stephan')

    INSERT @i VALUES ('Stephanie')

    INSERT @i VALUES ('Sterling')

    INSERT @i VALUES ('Steppenwolf')

    Then...

  • RE: wildcards

    ksatpute123 (9/11/2013)


    Ahh! Too many posts and none adding any value to the topic of discussion.

    Wrong question or not, if it was able to teach you something new or refresh...

  • RE: A Hazard of Using the SQL Update Statement

    Proiv

    http://www.proiv.com/

    We develop one code set for Windows, Sun & Linux with Oracle, then have to tweak it a bit to for Windows & SQLServer.

  • RE: Behavior of trigger

    Toreador (9/11/2013)


    Stewart "Arturius" Campbell (9/10/2013)


    another notch to my list of reasons to dislike triggers

    Really? Can't say this behaviour would appear anywhere on my list of bad things about triggers....

  • RE: A Hazard of Using the SQL Update Statement

    dwain.c (9/16/2013)


    marlon.seton (9/16/2013)


    We write all our code in Oracle first, where PL/SQL is needed, then produce the tSQL version afterwards where that is different, so we'd never have this problem...

  • RE: A Hazard of Using the SQL Update Statement

    We write all our code in Oracle first, where PL/SQL is needed, then produce the tSQL version afterwards where that is different, so we'd never have this problem (and I...

  • RE: CASE vagaries

    Revenant (9/10/2013)


    I am glad I got to answer this one after it was corrected. 😉

    Ditto

  • RE: Between & Collation

    Hugo Kornelis (8/29/2013)


    I decided to rely on my memory of lowercase/uppercase order instead of double checking. Bad decision. 😉

    Ditto.

  • RE: The Third Evolution

    'a person that loves technology and can inspire, excite, and drive the company'

    And this type of person grows on trees?

    Even if MS could find such a person, would the shareholders...

  • RE: Sales puzzle

    Pete Cox (8/16/2013)


    I was not proposing that the WHERE and the ORDER BY were cooperating in some way to get the 3 values of the result. Those 3 values match...

Viewing 15 posts - 46 through 60 (of 143 total)