Forum Replies Created

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

  • RE: Temporary Objects 2

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

    Thanks

    January 10, 2013 at 7:11 am

    #1575776

  • RE: VIEWS 2

    Nice One..

    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.

    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...

    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...

    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...

    January 9, 2013 at 6:52 am

    #1575223

  • RE: DateTime Functions

    Nice one..

    January 9, 2013 at 6:36 am

    #1575212

  • RE: Sequences I

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

    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...

    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....

    January 9, 2013 at 5:50 am

    #1575195

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

    Easy One..

    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,...

    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...

    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...

    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...

    January 9, 2013 at 4:21 am

    #1575149

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