Home Forums Article Discussions Article Discussions by Author Discuss content posted by Manoj Kumar How Truncate statement ? RE: How Truncate statement ?

  • October 21, 2010 at 7:46 am

    #1240315

    knmanojclt (10/21/2010)

    I was searching in the sql for 'costomermaster' in the entire sql but I didn't find anything.

    Thanks & Regards

    Manoj Kumar

    I really hope you are joking. If you are, then har har, you got us all by mispelling the QOTD and then making fun of our posts about your mistake.

    If you are not joking the section you 'missedspelling' is:

    TRUNCATE TABLE CustomerMast

    SELECT IDENT_CURRENT( 'CustomerMast' )

    Which completely changes the answer. There is no trucate error because the Truncate is not executed when there is no object found. The SELECT IDENT_CURRENT( 'CustomerMast' ) will always return NULL instead of 1 or 21 because there is no Identity records in the system tables for a table that does not exist.

    I hope you can find the Humorus in this myth stundering of your question.:cool: