rowtype in sqlserver

• zishanz

  SSCommitted

  Points: 1852

  More actions

  May 7, 2002 at 4:15 pm

  #78620

  Hi, in sqlserver, is there any rowtype data structure as in oracle.

  In oracle, when I declare a cursor like:

  Cursor attribute_cur

  IS

  select .....

  Then I can declare

  att_rec attribute_cur%rowtype

  so I don't have to declare variables to hold selected column values. Is there anything equivalent in sqlserver 2000?

  Thanks in advance.

  Abby

• Eve

  SSCrazy

  Points: 2480

  More actions

  May 7, 2002 at 10:42 pm

  #428669

  I don't think it exists.

  Here the link to the Microsoft article Migrating Oracle Databases to SQL Server 2000

  http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodtechnol/sql/reskit/sql2000/part2/c0761.asp

  Look at the User-Defined Integrity section with example

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 8, 2002 at 5:40 am

  #428689

  They are not supported and have no direct counterpart.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

• zishanz

  SSCommitted

  Points: 1852

  More actions

  May 8, 2002 at 12:01 pm

  #428734

  The website is very helpful.

  Thank you very much.

  Abby

• code4naveen

  SSC Enthusiast

  Points: 106

  More actions

  July 1, 2002 at 8:52 am

  #431912

  Ok thay dont have a direct counterpart but a datatype has been introdued in SQL server 2000 which can perform the required task in a similar way....Go through The topic Enhansments in any of the SQL server books...you will get the details...

  Naveen mehta