Thanks in advance
Quote:
Originally Posted by Taftheman
Hi can you insert nested tables in a table already exsisting in sql server and if so how would i go about do such a thing
Thanks in advance
You can in SQL 2005. See http://msdn2.microsoft.com/en-us/library/ms175659.aspx. You could also insert an XML blob, but this would be more like nesting a row. I would not recomend nexting XML. It uses up too much space because you end up with non-normalized data and makes selects for values in the XML field very slow, at best.
That said, be careful. This is pretty advanced stuff and hard to support long term.
