Search code examples
sql-serverplsqlnested-table

is there any thing like the nested table of oracle DB in sql-server

I was working with PL/SQL, and really found the nested table very helpful, now i'm working with sql server and i need sth like the nested table in oracle DB. all what i found is a data mining related.

Solution

  • Sorry, the concept of nesting tables in columns does not exist in SQL server (up to 2012). You can define User-defined Table Types, but you can't use them to persists data into tables.