Forum Replies Created

Viewing 15 posts - 451 through 465 (of 631 total)

  • RE: TRIGGERS

    I'm still not 100% if the misdirection was totally intentional, if so it was neatly executed, anyhow I wasn't fooled fortunately.

  • RE: Assigning values to Variables with CASE

    Toreador (4/3/2013)


    An object lesson in the need for well-commented code!

    +1

    Just a little help with the intention of some of the string manipulation might make the point clearer.

  • RE: Assigning values to Variables with CASE

    Toreador (4/3/2013)


    An object lesson in the need for well-commented code!

    +1

    Just a little help with the intention of some of the string manipulation might make the point clearer.

  • RE: Truncate Table

    I'm happy to admit I didn't know that one - it does make sense logically but I had to check.

  • RE: Delete v Truncate

    Raghavendra Mudugal (3/21/2013)

    ...

    - in general practice, as truncate removes all the records and no one wants to remove all the records from the table, only if any exceptional case where...

  • RE: SubQuery

    DugyC (3/8/2013)


    demonfox (3/7/2013)


    vinu512 (3/7/2013)


    The option is wrong....it is not necessary to have an Order By clause if Top is specified in a query.....it should be other way round.....Order By can...

  • RE: Can This Work?

    paul.knibbs (3/1/2013)


    Sean Pearce (3/1/2013)


    The question is "Will this code execute successfully?"

    and the only possible answer is "NO".

    Msg 111, Level 15, State 1, Procedure sp1, Line 11

    'CREATE/ALTER PROCEDURE' must be the...

  • RE: The Beer Cooler Thread

    I'm going to big up Sunny Republic:

    http://www.sunnyrepublic.com/

    Their American Brown Ale is among the nicest things I've drunk in a while. St Wites is good just not to my taste, I...

  • RE: OUTPUT - 1

    I honestly had not used the OUTPUT clause before, I can see how it would be helpful, so for me it's a good question, regardless of the case sensitivity blip.

  • RE: Basic SQLCMD Utilities

    I had not realised there is literally a utility for everything, so I guess that's handy to know. I'd used sqlcmd and bcp but it's always good to learn of...

  • RE: Bring Solutions

    @archie No it counts as being a smartarse (actually I hadn't thought of your answer so it was mildly interesting).

    On the editorial, indeed, if you are someone who offers a...

  • RE: The Lonely and Neglected Cartesian Product (Cross Join)

    archie flockhart (2/12/2013)


    I selected "none of these are correct".

    The first two are wrong for the reasons stated in the answer.

    The third is wrong because the requirements are that the three...

  • RE: Thesaurus Files

    No, I didn't see that coming, fortunately realised I knew nothing about it and did the legwork.

  • RE: Dealing with Supervision

    I think it's hard for any tech worker to operate with someone looking over their shoulder. I guess explaining the decisions you are faced with and why you are doing...

  • RE: Oops! SQL column swap or SQL column clobber?

    I managed to clobber my own post there I think :ermm:

Viewing 15 posts - 451 through 465 (of 631 total)