Home ›
ASP.NET Forums » Data Access » SQL Server, SQL Server Express, and SqlDataSource Control » array list in stored procedure is givving problem

array list in stored procedure is givving problem

Last post 07-08-2009 8:28 AM by om_prakashp. 1 replies.

Sort Posts:

  • array list in stored procedure is givving problem

    07-08-2009, 8:05 AM
    • Member
      point Member
    • vinnakanna
    • Member since 07-08-2009, 12:02 PM
    • Posts 1

    hi all,

    below code is not returning data but executing

    plz some one help

    create proc test1 (@t1 varchar(100))

    as  begin
    exec('SELECT  * FROM DataSource WHERE DataSourceName IN ('+@t1+')')
    end

    exec test1 'Ace Data S,ESIS Data Source'


    thnq
    Filed under:

  • Re: array list in stored procedure is givving problem

    07-08-2009, 8:28 AM
    Answer
    • Contributor
      2,142 point Contributor
    • om_prakashp
    • Member since 03-09-2009, 2:50 AM
    • Posts 312

    create proc test1 (@t1 varchar(100))

    as

    begin

     exec('SELECT * FROM DataSource WHERE DataSourceName IN ('''+@t1+''')')

    end

    Om Prakash
Page 1 of 1 (2 items)
RSS Available

Contact | Advertise | Ads by BanManPro | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.

Microsoft Communities