User-Defined Table Types in SQL Server 2005

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

Answer 1

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.

Answer 2

Table alias data types & Table-Valued parameters were introduced in SQL Server 2008 so are not available in prior versions.

Answer 3

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

Answer 4

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

Answer 5

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