Forum Replies Created

Viewing 15 posts - 106 through 120 (of 143 total)

  • RE: Changing from osql to sqlcmd

    Hi Steve,

    Thanks for your message.

    Yes, I've tried to search for the sqlcmd equivalent of -D and -n but to no avail.

    I've not considered SSIS because I know nothing about it...

    December 10, 2012 at 9:36 am

    #1567089

  • RE: PARSENAME

    Michael Riemer (10/25/2012)

    Another great question to learn from - thanks. I had heard of the function, but never knew what it did.

    I hadn't heard of it (so naturally didn't know...

    November 19, 2012 at 9:15 am

    #1560412

  • RE: stairway to T-SQL DML Level 10: Changing Data with the UPDATE Statement

    Re this format which I've never come across before:

    "UPDATE Product

    SET Price = N.Price

    FROM Product P JOIN New_Prices N

    ON P.ID =...

    October 31, 2012 at 3:47 am

    #1554520

  • RE: Inner Join

    Finally I can say 'thanks for the easy one'.

    October 4, 2012 at 1:55 am

    #1545367

  • RE: Stairway to T-SQL DML Level 11: How to Delete Rows from a Table

    Good article, thank you.

    One small thing, and it's nothing to do with the thrust of the article, but could people stop using 'criteria' when they mean the singular. It's...

    October 2, 2012 at 2:11 am

    #1544247

  • RE: Three Rules for Database Development

    djackson 22568 (9/17/2012)

    Testing sometimes finds bugs. Occasionally. Once in a while. Maybe only one or two...

    If testing doesn't find a bug the chances are the testing hasn't...

    September 27, 2012 at 2:23 am

    #1542745

  • RE: Three Rules for Database Development

    Phil Factor (9/17/2012)

    The idea of saying that one should never do shared database development is ridiculous, especially nowadays when you can have the best of both worlds and use database...

    September 27, 2012 at 2:19 am

    #1542744

  • RE: Fun with Outer Joins

    Often they are used to replicate data. Case in point is the [TerminationDate] of an employee. That column will be NULL for everyone who is still working and have a...

    September 20, 2012 at 1:49 am

    #1539922

  • RE: Fun with Outer Joins

    thisisfutile (9/11/2012)

    Like in a car, we don't reference left and right sides because that's relevant to whether or not I'm looking at it from the back or from the front....

    September 20, 2012 at 1:20 am

    #1539912

  • RE: Table Variable

    Andrew Watson-478275 (8/31/2012)

    Another point - the question would have required much more thought if one of the answers had been "1 SCREW, 2 SHOVEL, 3 SAW", which would have been...

    September 5, 2012 at 3:21 am

    #1533688

  • RE: Time Off

    Doctor Who 2 (8/22/2012)

    marlon.seton (8/22/2012)

    paul.knibbs (8/20/2012)

    Brandon Leach (8/20/2012)

    I've fallen into this trap many times. I'd find myself logging in to check on things on days off, etc.

    I do that...

    August 22, 2012 at 7:59 am

    #1528645

  • RE: Time Off

    Jasmine D. Adamson (8/21/2012)

    call.copse (8/21/2012)

    Raoul Bastendorff (8/20/2012)

    skron (8/20/2012)

    I actually ended up going back to work early after heart surgery because HR would not stop calling me to tell me that...

    August 22, 2012 at 2:03 am

    #1528488

  • RE: Time Off

    hisakimatama (8/20/2012)

    Wow. I'm actually kind of amazed at the amount of vacation time present in this thread :-P. This is only my first programming job, and I'm quite...

    August 22, 2012 at 1:56 am

    #1528485

  • RE: Time Off

    paul.knibbs (8/20/2012)

    Brandon Leach (8/20/2012)

    I've fallen into this trap many times. I'd find myself logging in to check on things on days off, etc.

    I do that too, but it's usually...

    August 22, 2012 at 1:53 am

    #1528482

  • RE: Time Off

    Raoul Bastendorff (8/20/2012)

    I switch my mobile phone off during those times.

    Such a simple thing to do. Why do people feel the need to be contactable all the time? ...

    August 22, 2012 at 1:47 am

    #1528478

Viewing 15 posts - 106 through 120 (of 143 total)