How to save a table (with its rows, columns and cells) in one single field in a SQL database and then display it on a webpage
views:
54answers:
2
+1
A:
You can select table as xml, and the XML result insert/update into the target cell as string (probably varchar).
TcKs
2009-07-17 12:03:42
Xml type column would probably be more appropriate (if available)...
ck
2009-07-17 12:06:22
A:
A: Either you design data structures and tables in you DB to hold those structures
or
B: you write your "Answers and Tables" to a BLOB (Binary data-field) in the DB.
I suggest you use A, unless you expect to have many or unstructured tables.
lexu
2009-07-17 13:42:05