Forum Replies Created

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

  • RE: Remove data from tables

    b) and f) are correct answer, as records from child is removed before parent. It is not mentioned any where that logging is required, and in production environment truncate...

  • RE: The Identity Limit

    CREATE TABLE TEST

    (

    nIDENTITY numeric(38,0) identity(10000000000000000000000000000000000000,1),

    nNo int)

    INSERT TEST

    SELECT 1

    UNION ALL

    SELECT 2

    SELECT LEN(nIDENTITY),nNo

    FROM TEST

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