Post reply

Regd. usage of Varchar(Max)

  • August 13, 2008 at 12:55 am

    #189320

    Hi,

    I use VARCHAR(MAX) for parameters (Not for fields), These parameters are used in the Where clause of the Query.

    for example.

    CREATE PROCEDURE [Sample]

    (

    @deliverycenter varchar(500)

    )

    as

    declare

    select * from itemdetails i where i.deliverycentercd in (@deliverycenter)

    .....

    Here instead of using varchar(500) can I use VARCHAR(Max), does it affects the performance.

  • August 13, 2008 at 1:00 am

    #857202

    No need to start a second thread.

    Please ditrect replies to the following thread, to keep all the discussion together

    http://www.sqlservercentral.com/Forums/Topic551587-360-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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