Post reply

Regarding string concatenation in stored procedures

  • May 3, 2006 at 7:53 am

    #190475

    hi,

    can any one suggest me for string concatenation inside stored procedures..

    alter proc sp_test as

    declare @temp1 varchar, @temp2 varchar, @temp3 varchar

    set @temp1='MS'

    set @temp2='SQL'

    set @temp3 = @temp1 + @temp2

    print @temp3

     

    whn i exec this-- sp_test

    output is--only M

    thanx in advance,

    ramesh.

  • May 3, 2006 at 7:57 am

    #635607

    Try giving the Variables sizes:

    declare @temp1 varchar(10), @temp2 varchar(10), @temp3 varchar(10)

    wayne

  • May 3, 2006 at 8:04 am

    #635622

    thanx wayneph 

    it is working

  • May 3, 2006 at 8:06 am

    #635628

    One note: building on Wayne's example, you probably want to make @temp3 varchar(20) - the sum of the length of @temp1 and @temp2.

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

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