Forum Replies Created

Viewing 15 posts - 1,306 through 1,320 (of 3,347 total)

  • RE: SET vs. SELECT

    Simon Jackson (7/14/2015)

    The answer is right, but I'm not convinced about the reasoning.

    If I replace the SET with SELECT , I get the same result.

    Just from experimenting, it seems to...

    July 14, 2015 at 4:21 am

    #1812253

  • RE: SQL for 8-year-old Math…But Be Careful of Implicit Type Conversion

    Nice article, David!

    I wrote about exact numerics not being exact a few years ago: http://sqlblog.com/blogs/hugo_kornelis/archive/2007/10/17/so-called-exact-numerics-are-not-at-all-exact.aspx

    When doing math with numeric data types, there are some rules for precision and scale of...

    July 14, 2015 at 3:06 am

    #1812233

  • RE: Extract the titles from XML

    SQLRNNR (7/13/2015)

    I see stats, memory grant info, cpu requirements, duration, number of pages, cost (granted it is based off some smoke and magic), number of rows, and even an implicit...

    July 13, 2015 at 4:40 pm

    #1812177

  • RE: Extract the titles from XML

    Like it or not (I don't), there are times when as a SQL Developer or SQL DBA you have no choice but to deal with XML (I have).

    I am not...

    July 13, 2015 at 1:14 pm

    #1812112

  • RE: A Case FOR Cursors...

    Jeff Moden (7/3/2015)

    andrew.norris 90251 (6/7/2015)

    Nothing wrong with cursors they have their place and are very useful.

    Do you have examples for something other hierarchies and bin stacking problems?

    A few examples I...

    July 4, 2015 at 1:51 am

    #1810266

  • RE: Dependency between tables

    julienchappel 38298 (7/1/2015)

    All tree answers are unrelated to the question of your exercise, i.e.: you are asking quote "What does this code return? " unquote and in all of the...

    July 2, 2015 at 1:34 am

    #1809731

  • RE: Integer lengths (I)

    Stewart "Arturius" Campbell (7/1/2015)

    ArnoKwetters (7/1/2015)

    Is NULL=NULL true ?

    NULL != NULL or anything else.

    NULL is actually a reflection of the state of the field, i.e. there is no value assigned to...

    July 1, 2015 at 11:34 am

    #1809619

  • RE: Dependency between tables

    I understand the people who claim that the first two answer options are the same, but I do not agree with them.

    I also disagree with the "correct" answer.

    The query returns...

    July 1, 2015 at 11:26 am

    #1809615

  • RE: What is the Output?

    radek.celuch (6/27/2015)

    This is quite interesting issue. I was curious if short-circuiting is also the case in UNION (ALL)/EXCEPT/INTERSECT operators.

    Below is my testing code.

    As a "let's see what this does" experiment,...

    June 28, 2015 at 1:04 am

    #1808620

  • RE: What is the Output?

    We cannot find a reference, but apparently the divide by zero doesn't cause an issue in the EXISTS() clause.

    The examples in this question are actually quite common. They are very...

    June 24, 2015 at 1:36 am

    #1807646

  • RE: Not so obvious COALESCE behaviour

    pparsons (6/17/2015)

    Not quite, it's still the COALESCE. In a comparison such as "select case when coalesce(cast (null as date),'')='' then 'true' else 'false' end" the result is "true" because...

    June 17, 2015 at 12:49 pm

    #1806186

  • RE: Not so obvious COALESCE behaviour

    ArnoKwetters (6/17/2015)

    Now the answer is NEVER.

    Without the RTRIM then the ansewer : IF NULL is right.

    It surprished me a bit when I use this code :

    DECLARE @anyDateTime date = null

    IF...

    June 17, 2015 at 1:50 am

    #1805954

  • RE: Column manipulation with ALTER TABLE

    I knew the answer, ticked (what I thought) the three correct options, then saw that I got it wrong, and the correct answer was exactly what (I thought) I selected.

    It...

    June 16, 2015 at 3:44 am

    #1805672

  • RE: What will happen with below code???

    roopa.subbareddy (6/14/2015)

    There is no Single quotes in the Select for the phone number. So it must give an error message.

    Try running the code. You'll see that the integer values...

    June 14, 2015 at 8:48 am

    #1805348

  • RE: Try Catch Throw

    wish.mannat (6/11/2015)

    Why am i getting these two errors on executing?

    Msg 102, Level 15, State 1, Procedure MyProc, Line 16

    Incorrect syntax near 'THROW'.

    Msg 2812, Level 16, State 62, Line 1

    Could not...

    June 11, 2015 at 12:57 pm

    #1804809

Viewing 15 posts - 1,306 through 1,320 (of 3,347 total)