locked
User-Defined Table Types in SQL Server 2005 RRS feed

  • Question

  • Hi,

    I am using SQL Server 2005 for some reasons, I have a requirement to create a User-Defined Table Types in SQL Server 2005.

    Any help.


    Please Mark it as Answered if it answered your question
    OR mark it as Helpful if it help you to solve your problem
    Elmozamil Elamir Hamid


    MCSE Data Platform MCITP: SQL Server 2008 Administration/Development
    MCSA: SQL Server 2012/2014
    MCTS: SQL Server Administration/Development
    MyBlog

    Tuesday, July 25, 2017 10:23 AM

Answers

All replies

  • I am using SQL Server 2005 for some reasons, I have a requirement to create a User-Defined Table Types in SQL Server 2005.

    So tell this person who gave you this requirement that they are asking you to take down the moon.

    If you give more information about your specific problem, that is the problem that lead to this impossible requirement, we may be able to help you a little better.

    Tuesday, July 25, 2017 10:38 AM
  • Table alias data types & Table-Valued parameters were introduced in SQL Server 2008 so are not available in prior versions.
    Tuesday, July 25, 2017 10:39 AM
  • If you give more information about your specific problem, that is the problem that lead to this impossible requirement, we may be able to help you a little better.

    Thanks very much for your response, the requirement is that a web page will be populated with a table data from TableA, a user will change value of some fields and then will insert data in new column, after that the user will press on submit. The idea for me is to use (as I do in SQL Server 2008 and above) Table-Valued parameters and pass it to store procedure then insertion in new table for new calculated data.

    I know CLR can do the work but I am trying to avoid it :) .



    Please Mark it as Answered if it answered your question
    OR mark it as Helpful if it help you to solve your problem
    Elmozamil Elamir Hamid


    MCSE Data Platform MCITP: SQL Server 2008 Administration/Development
    MCSA: SQL Server 2012/2014
    MCTS: SQL Server Administration/Development
    MyBlog


    Tuesday, July 25, 2017 11:00 AM
  • Table alias data types & Table-Valued parameters were introduced in SQL Server 2008 so are not available in prior versions.

    Thanks rakesh,

    What I am looking for is something in SQL Server 2005 that can do same functionality.


    Please Mark it as Answered if it answered your question
    OR mark it as Helpful if it help you to solve your problem
    Elmozamil Elamir Hamid


    MCSE Data Platform MCITP: SQL Server 2008 Administration/Development
    MCSA: SQL Server 2012/2014
    MCTS: SQL Server Administration/Development
    MyBlog

    Tuesday, July 25, 2017 11:00 AM
  • The best option for SQL 2005 is to package the data in an XML document. See chapter 7 in my article here for a quick start:
    http://www.sommarskog.se/arrays-in-sql-2005.html#XML

    • Proposed as answer by Xi Jin Wednesday, July 26, 2017 2:10 AM
    • Marked as answer by Elmozamil Elamir Wednesday, July 26, 2017 6:30 AM
    Tuesday, July 25, 2017 12:47 PM