Forum Replies Created

Viewing 15 posts - 3,121 through 3,135 (of 7,483 total)

  • RE: Behavior of trigger

    KWymore (9/10/2013)

    mtassin (9/10/2013)

    Jeff.MSSqlSage (9/10/2013)

    You guys certainly have an interesting definition of what defines "basics".

    I don't think an undocumented feature of the ALTER TRIGGER functionality qualifies as "basics".

    I don't know why...

    Tom

    September 10, 2013 at 6:09 pm

    #1649064

  • RE: Today's Random Word!

    sing4you (9/10/2013)

    L' Eomot Inversé (9/10/2013)

    Revenant (9/10/2013)

    crookj (9/10/2013)

    Ed Wagner (9/10/2013)

    SQLRNNR (9/10/2013)

    eggo

    Breakfast

    Second breakfast

    dim sum

    afternoon tea

    scones

    pancakes

    Tom

    September 10, 2013 at 9:42 am

    #1648953

  • RE: Today's Random Word!

    Revenant (9/10/2013)

    crookj (9/10/2013)

    Ed Wagner (9/10/2013)

    SQLRNNR (9/10/2013)

    eggo

    Breakfast

    Second breakfast

    dim sum

    afternoon tea

    Tom

    September 10, 2013 at 9:20 am

    #1648942

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (9/10/2013)

    jasona.work (9/10/2013)

    Koen Verbeeck (9/10/2013)

    Grant Fritchey (9/10/2013)

    L' Eomot Inversé (9/9/2013)

    Grant Fritchey (9/9/2013)

    Not sure anyone noticed, but we passed the three year anniversary of the thread. Thank the gods the...

    Tom

    September 10, 2013 at 6:19 am

    #1648833

  • RE: Behavior of trigger

    Nice question that illustrates an interesting undocumented feature.

    Richard Warr (9/10/2013)

    I found some supporting documentation here. Seems a bit of a "hidden gem" though :crazy:

    Back in May Microsoft said this was...

    Tom

    September 10, 2013 at 5:57 am

    #1648825

  • RE: CASE vagaries

    Steve Jones - SSC Editor (9/9/2013)

    A poor question, and incorrect answers. My apologies. I know I ran the code, but I'm guessing I didn't examine the answers closely enough.

    I have...

    Tom

    September 9, 2013 at 8:43 pm

    #1648698

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/9/2013)

    Not sure anyone noticed, but we passed the three year anniversary of the thread. Thank the gods the terrible twos are over. Our little... thread... is a toddler...

    Tom

    September 9, 2013 at 8:22 pm

    #1648697

  • RE: comparing a column to Todays date

    SQLTestUser (9/9/2013)

    -- should this be datetime if i have Sql server 2005?

    No, if you are on 2005 you need something more complicated - as batgirl suggested,

    convert(datetime, datediff(0, DD, getdate()))...

    Tom

    September 9, 2013 at 3:58 pm

    #1648673

  • RE: Holiday Breaks

    KWymore (9/3/2013)

    It's now up to 73% correct. Do you think it will top out at 77%?

    Six days on it's still at 73%. I think it'll stay there. Which...

    Tom

    September 9, 2013 at 12:38 pm

    #1648636

  • RE: comparing a column to Todays date

    The conversion to INT may be part of the problem. But Convert(datetime, Convert(int, GetDate())) should deliver midnight tonight, not midnight this morning, so it's surprising you are getting any...

    Tom

    September 9, 2013 at 12:02 pm

    #1648633

  • RE: round down

    ScottPletcher (9/9/2013)

    You can get the result you need: the specific method depends on specifically what you need to do. If you can provide sample values and the desired results,...

    Tom

    September 9, 2013 at 10:48 am

    #1648611

  • RE: The Loss of Trust

    Steve Jones - SSC Editor (9/9/2013)

    No idea. It might be, but I'm concerned with the point made of public (law enforcement) cameras forced on private property. When might some "filter"...

    Tom

    September 9, 2013 at 10:31 am

    #1648607

  • RE: The Loss of Trust

    hisakimatama (9/9/2013)

    I agree that the NSA's conduct and invasion of privacy are quite quesionable, but as long as we're only given candidates that are compliant with them in our polls,...

    Tom

    September 9, 2013 at 9:41 am

    #1648586

  • RE: The Loss of Trust

    dtevlin 55845 (9/9/2013)

    You do need encryption for your business data, but the group you need to be wary of is China and Russia. They have a long history of economic...

    Tom

    September 9, 2013 at 8:35 am

    #1648562

  • RE: The Loss of Trust

    Steve Jones - SSC Editor (9/8/2013)

    Ugh. How long before we have people spying on our databases as well? A sad, sad, time.

    What? You mean you think it isn't already...

    Tom

    September 9, 2013 at 8:12 am

    #1648556

Viewing 15 posts - 3,121 through 3,135 (of 7,483 total)