Forum Replies Created

Viewing 15 posts - 3,586 through 3,600 (of 7,484 total)

  • RE: SQL JOINS

    Hugo Kornelis (4/15/2013)


    Calling a column ID and then putting duplicate values in it is just evil. No raise for the developer who wrote this, and a warning that (s)he'll be...

  • RE: Endpoints

    khelloufsofiane 6183 (4/14/2013)


    Hi Everybody,

    I think there is also SOAP type.

    Thanks

    Not in SQL Server 2012.

    The trouble is that not all parts of Books On Line have been updated correctly. In...

  • RE: Create DML trigger for single table in SQL 2008 and send email alert to group

    Lynn Pettis (4/12/2013)


    I have to agree with Steve on this one.

    Me too. I've always put stuff in a table and had a scheduled job which reads the table and...

  • RE: Endpoints

    Interesting question. Of course none of the answer options is actually correct because the all say TCP where they mean T-SQL but that won't confuse anyone.

    It's sort of nice...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/11/2013)


    Jan Van der Eecken (4/11/2013)


    Lynn Pettis (4/11/2013)


    This really makes one want to help, doesn't it.

    Dunno, but it really looks like he was dumped into getting this job done.

    Yes,...

  • RE: Create DML trigger for single table in SQL 2008 and send email alert to group

    I should have said that you can get much of what you want from the SYSTEM_USER built in function and by using DBCC INPUTBUFFER to populate a table with details...

  • RE: Are the posted questions getting worse?

    Jan Van der Eecken (4/11/2013)


    Lynn Pettis (4/11/2013)


    This really makes one want to help, doesn't it.

    Dunno, but it really looks like he was dumped into getting this job done.

    Well, I've stepped...

  • RE: Create DML trigger for single table in SQL 2008 and send email alert to group

    krishnavenkat16 (4/10/2013)


    Hi,

    i have a requirement to Create DML trigger for single table ( check for any updates ) in SQL 2008 and send email alert to group if there is...

  • RE: Question Regarding Implementing a Work Schedule Table

    autoexcrement (4/11/2013)


    I'm just some guy, but it seems that the answer depends on the specifics of your situation.

    Yes, that's certainly true. It almost always is.

    A week will always...

  • RE: films database (yeah, yeah, hear me out!)

    I think your concern #2 is something you shouldn't let happen.

    Concern #1 can perhaps be answered by saying don't put the name in the people table. Instead of people and...

  • RE: Identity Columns

    Good clear question.

    It's surprising that almost a quarter of people got it wrong. Maybe a lot of people don't use identity columns, so don't know the rules about them?

  • RE: Today's Random Word!

    JAZZ Master (4/9/2013)


    Daniel Bowlin (4/9/2013)


    SQLRNNR (4/8/2013)


    crookj (4/8/2013)


    Revenant (4/8/2013)


    SQLRNNR (4/8/2013)


    backbend

    yoga

    Yogi

    Yogurt

    Frozen

    Pizza

    inedible (when frozen)

  • RE: TRIGGERS

    Hugo Kornelis (4/9/2013)


    I'm glad I double and triple checked before replying; I almost fell for it. The glaring error in how the trigger code handles multi-row inserts is so staring...

  • RE: ISNUMERIC

    Hugo Kornelis (4/8/2013)


    nenad-zivkovic (4/8/2013)


    I hope someone else can explain why a backslash at the start of the string is considered numeric, as I was surprised at that myself.

    I've managed to...

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    Jeff Moden (4/6/2013)


    L' Eomot Inversé (4/6/2013)


    The order of elements in the result string is not guaranteed to be determined by the order by clause, so...

    I've heard about that but haven't...

Viewing 15 posts - 3,586 through 3,600 (of 7,484 total)