Post reply

rowtype in sqlserver

  • 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

  • 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

  • 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)

  • May 8, 2002 at 12:01 pm

    #428734

    The website is very helpful.

    Thank you very much.

    Abby

  • 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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply