T-SQL Table variable and %ROWTYPE in Oracle

• Sylvain Coutu

  Ten Centuries

  Points: 1077

  More actions

  November 12, 2004 at 1:52 pm

  #59728

  Is their any thing that does the same as Oracle %ROWTYPE that create the record type as the same as the table.

   

  I want to avoid this T-SQL code :

  DECLARE @myTable TABLE

  ( @field1 VARCHAR(10), @field2 VARCHAR(10), ..... )

  and have something like Oracle PL/SQL :

  DECLARE

       TYPE curtype IS REF CURSOR

            RETURN myTable%ROWTYPE

       -- Then declare a Cursor as same as curtype

  ....

   

  Any Ideas?

• Jeff Moden

  SSC Guru

  Points: 1004600

  More actions

  November 14, 2004 at 7:04 pm

  #530055

  Yes, there is, kind of, but I don't know if it will work with a cursor (I avoid cursors) and it uses a temp table (no so bad if proper resources allocated to TempDB) instead of a table variable... here's an oversimplified example...

  SELECT *

    INTO #MyTemp

    FROM yourtable

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)