Post reply

can varchar length in convert or cast decrease performace of sqlserver 2005

  • March 8, 2012 at 8:27 am

    #146699

    Dear all,

    i am creating hyperlink from stored procedure

    ex.

    table name is emp and col1 is bigint.

    select '<span><a target="_blank" href="index.htm'+CAST(col1 as varchar(20))+'">Index</a></span>'

    from emp

    i can use varchar(30) in place of varchar(20) in above case.

    my question is,can the increase of length of varchar 20 to 30 can decrease the performace of sqlserver 2005 in any situation.

    (please consider that i have more than 200 stored procedure where i am creating many links as shown above)

    yours faithfully

  • March 8, 2012 at 8:29 am

    #1456567

    Almost exactly the same as this question: http://www.sqlservercentral.com/Forums/Topic1263657-149-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