Forum Replies Created

Viewing 15 posts - 61 through 75 (of 101 total)

  • RE: SQL Jobs

    Nakul Vachhrajani (3/27/2015)


    ...reminds me of algebra and how it's impossible to solve for two unknowns with just one equation!

    xy=1 where x and y are positive integers

    x=1, y=1

    😀

  • RE: SQL Jobs

    Stewart "Arturius" Campbell (3/26/2015)


    ...i always asked "why" when users wanted development done

    asking that about 5 or 6 times really makes the user think...

    It usually makes them think 'if he asks...

  • RE: SQL Jobs

    Joy Smith San (3/26/2015)


    I created a job with only the command

    "Select getdate())" which has syntax error in it.

    The job failed. But,

    1. It created the file when it was not there.

    2....

  • RE: Delete

    Carlo Romagnano (3/24/2015)


    Extremely easy!

    Why 2 points?

    🙂

    Speak for yourself - plenty of people get confused about multiple foreign keys and cascade deletes. They're all extremely easy when you know the answer.

  • RE: The mysteries of life, the beginning of the 20th century

    Msg 102, Level 15, State 1, Line 1

    Incorrect syntax near '('.

    Msg 137, Level 15, State 2, Line 2

    Must declare the scalar variable "@".

    I am stuck as to where the 'correct'...

  • RE: Drop Database

    Oh yeah I forgot the quotes - doh - 14,600 ohysical results (lots of ohysical education, ohysical properties, ohysical therapy...) - quite a few in the URL and some very...

  • RE: Drop Database

    The second answer couldn't have been correct as there's no such thing as an ohysical file 😀 - although it must be a common typo as Google gives 107,000 results...

  • RE: Basic Date Function

    crmitchell (2/15/2013)


    The time returned by the server being offset implies the two boxes are set to different times

    But what implies there are two boxes?

    I can tell you're not gong to...

  • RE: Basic Date Function

    crmitchell (2/15/2013)


    L' Eomot Inversé (2/15/2013)


    What worries me there is that - even with the very appropriate emoticon - the person to whom you replied may be insufficiently awake to detect...

  • RE: Basic Date Function

    crmitchell (2/15/2013)


    L' Eomot Inversé (2/14/2013)


    Koen Verbeeck (2/13/2013)


    This question could've been better if the question asker realized there are more than one countries in the world.

    Actually, all we need to know...

  • RE: Basic Date Function

    How can there be so many wrong answers??

    SYSDATETIME would just give you current time, there's no offset displayed, and CURRENT_TIMESTAMP doesn't give enough fractional seconds, so there's only one possible...

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

    Now my question to you: Is the company sponsored employee & spouse/partner formal dinner and dance, a benefit enjoyed in a bygone era?

    "company sponsored"... does not compute??#!? I have...

  • RE: Creating Tables

    binod.soft (2/10/2013)


    The Statement has three GO syntax which indicates three Batches. Each Go used shows an end of the Batch.

    Yes, there's not really any getting round that - however...

  • RE: Basic maths - operator precedence

    sknox (2/6/2013)


    To a computer, there are no intrinsic numerators and denominators in the statement

    8 / 4 x 2

    There are only operators and operands. If you choose the multiplication operator first,...

  • RE: Basic maths - operator precedence

    sknox (2/6/2013)


    Always work left-to-right -- don't give precedence to an operation on the same level.

    For example, take

    8 / 4 x 2

    The correct way is left-to-right:

    8 / 4 = 2 x...

Viewing 15 posts - 61 through 75 (of 101 total)