tags:

views:

54

answers:

2

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

+1  A: 

You can select table as xml, and the XML result insert/update into the target cell as string (probably varchar).

TcKs
Xml type column would probably be more appropriate (if available)...
ck
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