Array variable in store procedure

Last post 05-08-2008 12:33 PM by megetron. 3 replies.

Sort Posts:

  • Array variable in store procedure

    03-09-2008, 6:46 AM
    • Loading...
    • megetron
    • Joined on 03-13-2006, 5:38 AM
    • Posts 407

    Hello,

    Do you know how can I define and initiate array of TINYINT ?
    I am googling but cannot find anything about that...

  • Re: Array variable in store procedure

    03-09-2008, 10:44 AM

    Have a look at these: 

    How to pass a list of values or array to SQL Server stored procedure?
    http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm

    How to pass array of values into SQL Server stored procedure using XML and Visual Basic .NET
    http://support.microsoft.com/kb/555266

     

     

    --------------------------------------------------------
    Don't forget to click "Mark as Answer" on the post(s) that helped you.

    Scott ASP.net blog

  • Re: Array variable in store procedure

    03-09-2008, 11:14 AM
    • Loading...
    • megetron
    • Joined on 03-13-2006, 5:38 AM
    • Posts 407

    I am using mySQL darabase....
    and I don't need pass variables, obnly DECLARE in array in a store procedue, that's all....

  • Re: Array variable in store procedure

    05-08-2008, 12:33 PM
    Answer
    • Loading...
    • megetron
    • Joined on 03-13-2006, 5:38 AM
    • Posts 407

    TABLE is the equivalent for Array.

Page 1 of 1 (4 items)
Microsoft Communities
Page view counter