Free Jobs
Reference




Dot Net Forums: ASPNET (77) C#.NET (39) VB.NET (8) AJAX (21) Silver Light (1) WCF (10) WPF (1) WWF (1) .NET 3.5 (3) SQL SERVER (38) Other (3)

Topic: How to return string array or delimited string from a stored procedure or sp

To get the Posted Questions details daily in your mail Click Here

Share this Post on Facebook/Twitter/Orkut Bookmark and Share





User: manishav3388 Post Date: 23 May 2012 13:06

Introduction:
How to return string array or delimited string from a stored procedure or sp



Main Content:

CREATE procedure [dbo].[Test_Test_sp1]

     (

        @param1        char(15)   = Null,

        @param2        varchar(119)  = Null,

        @param3        varchar(49)  = Null

     )

AS

     BEGIN

    

     declare @var1    char(15)    

     declare @var2    varchar(119)

     declare @var3    varchar(49)

     declare @return_value   varchar(200)

    

     SET @var1 = (SELECT column1 from Table1  br  join Table2 brd on br.id = brd.ID

     WHERE column3 =@param1)

    

     SET @var2 = (SELECT column1 from Table1  br  join Table2 brd on br.id = brd.ID

     WHERE column3 =@param1)

     

         

     if(@var1 is null or @var1 = '''')

     begin

     SET @var1 =  @param1

     end

    

     if(@var2 is null or @var2 = '''')

     begin

     SET @var2 =  @param2 

     end 

    

     set @return_value = @var1 +'',''+@var2

    

     select @return_value


     END

 





 


Conclusion:
this way we can return string array or delimited string from a stored procedure or sp



About Writer:
hello,I am JAVA Developer from Noida.


Writer's Link: http://

Writer's Email:







Comments:
Post Comment





Similar Articles Top ArticlesLatest Articles Other Articles by this Author







www.freejobsreference.com Copyright © 2009-2011 | All Rights Reserved
All content of this website is protected by copyright laws and should not be reproduced in any form or by any means without written permission
(Best viewed in IE 8.0+ or Firefox 3.0+ at resolution of 1024 * 768 or higher)