"table" datatype!


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: "table" datatype!

  1. #1
    Francisco Espinoza Guest

    "table" datatype!


    Hi!
    I need to Know if I can use a parameter in a procedure, with the table datatype!
    like this:

    create proc pTest (@par1 table(column1 int, column2 int))

    Thanx a lot!
    Francisco Espinoza

  2. #2
    David Satz Guest

    Re: "table" datatype!

    from SQL Server 2000 BOL:

    A special data type that can be used to store a result set for later
    processing. Its primary use is for temporary storage of a set of rows, which
    are to be returned as the result set of a table-valued function.

    so - No
    --
    HTH,
    David Satz
    Principal Web Engineer
    Hyperion Solutions
    { SQL Server 2000 SP1/7.0 SP3/6.5 SP5a } { Cold Fusion 5/4.5.1 SP2 } { VSS }
    (Please reply to group only - emails answered rarely)
    -----------------------------------------------------------------
    "Francisco Espinoza" <espinozaf@bol.com.br> wrote in message
    news:3c4576e0$1@147.208.176.211...
    >
    > Hi!
    > I need to Know if I can use a parameter in a procedure, with the table

    datatype!
    > like this:
    >
    > create proc pTest (@par1 table(column1 int, column2 int))
    >
    > Thanx a lot!
    > Francisco Espinoza




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center