Post reply

Width for Procedure Parameters

  • October 13, 2004 at 6:53 am

    #526501

    From BOL

    varchar[(n)]

    When n is not specified in a data definition or variable declaration statement, the default length is 1. When n is not specified with the CAST function, the default length is 30.

    So, to answer your question, always specify the length, even if it is one, it is good practice and lazy not to do so. Besides, if Microsoft ever changed this default (unlikely, but you never know) then you would have trouble in the future.

     

    Far away is close at hand in the images of elsewhere.
    Anon.

  • October 13, 2004 at 6:58 am

    #526505

    Short and simple, always provide the width with char, varchar and varbinary. And always set the precision and scale for numeric, decimal and so on.

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

You must be logged in to reply to this topic. Login to reply