Home Forums Article Discussions Article Discussions by Author Discuss content posted by Chris Morton Truncate Referenced Table RE: Truncate Referenced Table

  • January 19, 2009 at 6:36 pm

    #929436

    Tim.Wilson-Brown (1/19/2009)

    Is there any reason why you used NVARCHAR(128) rather than SYSNAME?

    SYSNAME would make the script more portable between versions - and enforce restrictions on content.

    I agree that SYSNAME would be more appropriate, but SYSNAME is nothing more than a synonym for a NOT NULL NVARCHAR(128). From BOL...

    sysname is a system-supplied user-defined data type that is functionally equivalent to nvarchar(128), except that it is not nullable. sysname is used to reference database object names.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)