Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    1

    Question Unanswered: oracle rowtype equivalent in T-Sql or SQL Server

    Hi,

    I am looking for an equivalent to %ROWTYPE of Oracle in SQL SERVER,
    Please dont tell me that i need to use 100 or 200 variables if my cursor is having those many fields, as that will reduce the performance of the stored procedure where i need the solution.

    Venkat

  2. #2
    Join Date
    Apr 2003
    Location
    Israel
    Posts
    81
    Hi,

    Maybe, you could use a table variable that will contain only 1 row ?
    --
    kukuk

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •