Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: STUFF Function

    Toreador (5/17/2011)

    Koen Verbeeck (5/16/2011)

    And the explanation doesn't mention why inserting NULL in another string doesn't result in NULL, but in an empty space instead.

    That's what got me.

    Surely it's a bug?

    select...

    May 19, 2011 at 9:35 am

    #1327176

  • RE: What identity comes next?

    So, can we say that what SQL Server does to determine the next identity

    value is:

    Select Sign(Ident_Incr('tablename')) * Max(Sign(Ident_Incr('tablename')) * $IDENTITY) + Ident_Incr('tablename')

    From tablename

    where $IDENTITY is the identity column of table...

    September 29, 2010 at 4:35 pm

    #1229393

Viewing 2 posts - 1 through 2 (of 2 total)