Forum Replies Created

Viewing 15 posts - 841 through 855 (of 8,416 total)

  • RE: Twist in ISNULL function

    Koen Verbeeck (2/2/2012)

    SQL Kiwi (2/2/2012)

    An article about clearly documented behaviour, and no mention of the more serious problems with COALESCE? Poor.

    Now you make me curious. Which issues are you...

    February 2, 2012 at 1:02 am

    #1441580

  • RE: INSERT OUTPUT

    Koen Verbeeck (2/1/2012)

    Great question. I was looking for a trap, but apparently there wasn't any 😀

    Me too. I was expecting:

    GO

    CREATE TABLE dbo.Test

    (

    ID ...

    February 2, 2012 at 12:27 am

    #1441565

  • RE: Twist in ISNULL function

    An article about clearly documented behaviour, and no mention of the more serious problems with COALESCE? Poor.

    February 2, 2012 at 12:07 am

    #1441555

  • RE: Join - that may not be possible

    danielfountain (2/1/2012)

    I am not 100% sure what the numbers table is exactly doing - but i will look at it in more detail shortly.

    Thanks. If you mean the weird-looking...

    February 1, 2012 at 5:52 am

    #1441161

  • RE: Computed Columns 1

    danielfountain (2/1/2012)

    However the question was still wrong as you still dont reference another column. You reference a UDF.

    Meh, semantics.

    February 1, 2012 at 1:15 am

    #1441071

  • RE: SET option hierarchy

    honza.mf (2/1/2012)

    I propose to switch the answers #4 and #5. The answer All of above becomes correct in this order.

    :laugh: I like it!

    February 1, 2012 at 1:14 am

    #1441070

  • RE: Help with Case in where clause

    You may find this form makes better use of any indexes you might have:

    IF @Option = 1

    BEGIN

    SELECT *

    FROM dbo.Inventory AS...

    January 31, 2012 at 11:51 pm

    #1441049

  • RE: SET option hierarchy

    A confused question with no right answer. All of the above indeed :rolleyes:

    January 31, 2012 at 11:11 pm

    #1441043

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/31/2012)

    SQL Kiwi (1/31/2012)

    Ok, the embedded quotes occupy a whole screen now...

    I need a filter to whack multiple embedded quotes. It can be quite annoying.

    Great idea!

    This...

    January 31, 2012 at 12:44 pm

    #1440919

  • RE: Are the posted questions getting worse?

    Ok, the embedded quotes occupy a whole screen now...

    January 31, 2012 at 12:29 pm

    #1440905

  • RE: Automatic truncate of varchar string

    jcb (1/31/2012)

    "can't do" attitude is bad for everyone and works both sides.

    Just go direct to the point: Deactivating this messagens ill deactivate also usefull messages and you cannot guarantee correctness...

    January 31, 2012 at 12:14 pm

    #1440895

  • RE: Automatic truncate of varchar string

    SQLKnowItAll (1/31/2012)

    As long as you say it with a positive attitude and maybe a little "I really wish I could, but I just can't figure out how to allow bad...

    January 31, 2012 at 12:14 pm

    #1440894

  • RE: Understanding and Using APPLY (Part 2)

    b5535084 (1/31/2012)

    TOP: CPU time = 1281 ms, elapsed time = 7777 ms, logical reads 223933 (ORDER_ITEM_DIM)

    ROW_NUMBER: CPU time = 2000 ms, elapsed time = 15948 ms, logical reads 303216 (ORDER_ITEM_DIM)

    TOP...

    January 31, 2012 at 11:47 am

    #1440869

  • RE: Automatic truncate of varchar string

    SQLKnowItAll (1/31/2012)

    Personally... I would tell them no. We don't truncate data at the database level with SQL Server. Tell them it is not possible and that they simply have...

    January 31, 2012 at 11:37 am

    #1440859

  • RE: Automatic truncate of varchar string

    GilaMonster (1/31/2012)

    SQL Kiwi (1/31/2012)

    GilaMonster (1/31/2012)

    jcb (1/31/2012)

    Can You rely on a trigger to safe truncate the data to the column?

    No, because types are checked before triggers fire.

    Yes, if you use a...

    January 31, 2012 at 11:35 am

    #1440856

Viewing 15 posts - 841 through 855 (of 8,416 total)