Problem solve Get help with specific problems with your technologies, process and projects.

Building nested tables in SQL Server?

Is it possible to build nested tables in SQL Server (I have good knowledge of Oracle and have used nested tables in Oracle for quite some time now)? I studied a few articles on that state that this is possible using data mining, but I'm not sure of this concept of data mining. My prime concern is that I should be able to access the nested tables (maybe I can also do away with multidimensional arrays in a column in an SQL Server Table, if possible) should be accessible from a RAD such as Visual Basic/.NET/PowerBuilder using ODBC/OLEDB techniques.

I have no idea what a nested table is. I'm assuming that you are embedding a table of information inside another table of information. If so, you can not do this in SQL Server. SQL Server also does not support arrays.

Dig Deeper on Microsoft SQL Server Installation