Forum Replies Created

Viewing 15 posts - 121 through 135 (of 188 total)

  • RE: Temporary Objects 2

    Can anyone help me in simulating the question in management studio without any application.

    Thanks

    --
    Dineshbabu
    Desire to learn new things..

    January 10, 2013 at 7:11 am

    #1575776

  • RE: VIEWS 2

    Nice One..

    --
    Dineshbabu
    Desire to learn new things..

    January 10, 2013 at 6:34 am

    #1575748

  • RE: VIEWS 3

    Nice question and nice reference in answer.. I lost patiencce on reading the entire explaination provided in BOL..

    But really a great stuff.

    --
    Dineshbabu
    Desire to learn new things..

    January 10, 2013 at 6:15 am

    #1575738

  • RE: VIEWS 4

    Hugo Kornelis (3/27/2012)

    What exactly are you confused about? This question is not at odds with the "unexpected results" quote in Books Online, as this error is just one of the...

    --
    Dineshbabu
    Desire to learn new things..

    January 10, 2013 at 5:15 am

    #1575721

  • RE: Precedence in math

    Very simple one.. You could have made it bit complex by adding few expressions of same precedence or different level without parenthesis. That will help us to think more..

    Thanks...

    --
    Dineshbabu
    Desire to learn new things..

    January 9, 2013 at 11:49 pm

    #1575606

  • RE: VIEWS 5

    Hugo Kornelis (10/9/2012)

    The definition of the view will not pick up changes made to the table at a later time, unless sp_refreshview is used or the view is recreated.

    Hi...

    --
    Dineshbabu
    Desire to learn new things..

    January 9, 2013 at 6:52 am

    #1575223

  • RE: DateTime Functions

    Nice one..

    --
    Dineshbabu
    Desire to learn new things..

    January 9, 2013 at 6:36 am

    #1575212

  • RE: Sequences I

    Before answering referred BOL many times, so i got it correct..

    --
    Dineshbabu
    Desire to learn new things..

    January 9, 2013 at 6:30 am

    #1575209

  • RE: Sequences II

    dawryn (4/24/2012)

    tommyh (4/23/2012)

    Startvalue will be MinValue (since its not given).

    Check reference again. Start value is different whether sequence is ascending or descending.

    without properly understanding difference between asc and desc. I...

    --
    Dineshbabu
    Desire to learn new things..

    January 9, 2013 at 6:10 am

    #1575197

  • RE: Sequences III

    Still i didn't get a chance to work in 2012, But keeping property of IDENTITY and minimum value of INT in mind I answered and luckily i got it correct....

    --
    Dineshbabu
    Desire to learn new things..

    January 9, 2013 at 5:50 am

    #1575195

  • RE: What is the logical Processing order of select statement

    Easy One..

    --
    Dineshbabu
    Desire to learn new things..

    January 9, 2013 at 5:36 am

    #1575192

  • RE: SELECT * usage

    Hugo Kornelis (5/10/2012)

    jalvarocrespo (5/10/2012)

    Tricky question indeed.

    Well, but I can't find any difference between the result obtained and my response: When the table contains sparse columns and a sparse column set,...

    --
    Dineshbabu
    Desire to learn new things..

    January 9, 2013 at 5:15 am

    #1575183

  • RE: Transactions 2

    I answered 1 row.

    Assuming violation is at second row so first row will be xcuted succesffully. One more thing i didn't notice that all three insert statements are inside a...

    --
    Dineshbabu
    Desire to learn new things..

    January 9, 2013 at 5:06 am

    #1575176

  • RE: Logical Operators

    ronmoses (5/24/2012)

    The only reason I had to think about it a while is that I would never combine AND and OR without parentheses, so that fact was a bit dusty...

    --
    Dineshbabu
    Desire to learn new things..

    January 9, 2013 at 4:28 am

    #1575153

  • RE: Logical Operators

    Toreador (5/24/2012)

    I can't believe that 21% have currently got it completely wrong, thinking that OR has precedence over AND! Hopefully they're just all misunderstanding what 'precedence' means 😉

    I'm one of...

    --
    Dineshbabu
    Desire to learn new things..

    January 9, 2013 at 4:21 am

    #1575149

Viewing 15 posts - 121 through 135 (of 188 total)