Forum Replies Created

Viewing 15 posts - 211 through 225 (of 234 total)

  • RE: SELECT @local_variable

    Christian Buettner-167247 (12/14/2009)

    Hi Honza,

    I know it's not documented - I just would like to know if someone knows what is going on behind the scenes. I am just curious. My...

    December 14, 2009 at 5:00 am

    #1091859

  • RE: SELECT @local_variable

    Toreador (12/14/2009)

    I guessed rigtht, but only because I knew it had to begin with 'Question' and there was only one answer that did that. If there'd been an option for...

    December 14, 2009 at 4:53 am

    #1091854

  • RE: SELECT @local_variable

    Christian Buettner-167247 (12/14/2009)

    Hm, is someone able to explain this?

    Same code as before, but positioned order by (1 instead of i) and "-" as separator for better readability.

    As said in explanation:

    The...

    December 14, 2009 at 2:49 am

    #1091821

  • RE: Clustered Index Internals

    Sorry, I wasn't able to understand the last option. Even after few attempts to translate to some other language.

    December 9, 2009 at 7:14 am

    #1089824

  • RE: 4 Ways to Increase Your Salary (Using UPDATE)

    The last example uses assumption on the identity column values in the main table.

    You can just add these values to the temp table.

    But Martin's solution is better

    November 26, 2009 at 6:12 am

    #1084566

  • RE: Variables, Nulls and Coalesce

    gary.rumble (11/25/2009)

    Tom Garth (11/25/2009)

    The 2nd SELECT has no ORDER BY clause, and the table variable has no index. How do you know what the last row will contain?

    😛

    The second query...

    November 25, 2009 at 1:51 pm

    #1084340

  • RE: Variables, Nulls and Coalesce

    :w00t:

    I know very well how this assignments work. So it was just my great answering problem: Don't miss the right radio button. 😀

    November 25, 2009 at 4:22 am

    #1083898

  • RE: T-SQL

    David Easley-401108 (11/20/2009)

    this is kind of like going to a math class and asking what is 1+1

    everyone who answers 2 is wrong, since i was asking the question in base2,...

    November 20, 2009 at 8:20 am

    #1082260

  • RE: T-SQL

    bitbucket-25253 (11/19/2009)

    honza.mf

    ???? ????

    - Russian - in english Foucault (given the name of its discoverer who was a physicist (1819-1868):

    "Is a closed electrical eddy currents in massive conductor, which...

    November 19, 2009 at 10:34 am

    #1081711

  • RE: T-SQL

    cengland0 (11/19/2009)

    honza.mf (11/19/2009)

    Try Google itself. One of the first links leads to ?????????, use English on the left side.

    Translator ommited the first word. To tell the truth, the more simple...

    November 19, 2009 at 4:08 am

    #1081454

  • RE: T-SQL

    cengland0 (11/19/2009)

    honza.mf (11/19/2009)

    Just for fun: ???? ????

    Try to discover, what does it mean.

    According to Google Translate, it means: Foucault

    Don't know what that means but when I look it up...

    November 19, 2009 at 3:30 am

    #1081433

  • RE: T-SQL

    Karin.Nooteboom-1039448 (11/19/2009)

    However these kind of tricky question are ridiculous. They assume that all members of the site speak perfect English and understand the subtle nuances in the phrasing of...

    November 19, 2009 at 3:04 am

    #1081416

  • RE: T-SQL

    archie flockhart (11/18/2009)

    Lynn Pettis (11/17/2009)

    So, you are saying that if I run the following code:

    select getdate(), getutcdate()

    that the values are not equivalent? Why? They both represent the same...

    November 18, 2009 at 1:11 pm

    #1081169

  • RE: T-SQL

    Lynn Pettis (11/18/2009)

    honza.mf (11/18/2009)

    Sorry, results are neither same nor equivalent. They are different.

    Once more: Even the variables don't have a flag showing time zone or UTC information.

    The results shows the...

    November 18, 2009 at 7:21 am

    #1080887

  • RE: T-SQL

    Steve Jones - Editor (11/17/2009)

    I have awarded back all points to people as of now. Apologies for the delay, but this was not the high priority of the day.

    The question...

    November 18, 2009 at 5:40 am

    #1080815

Viewing 15 posts - 211 through 225 (of 234 total)