Dear Geeks! I have a page where i have to fetch data from db (Includes 9 procs) and show it in tabular format, now need it to save this static page data in db like html or pdf so what is best approach to accomplish thisk task and what must be datatype for this content. thanks in advance !!!!!!!
PDF and HTML are two very different data types. A PDF would be stored in a binary column. HTML could maybe be stored in one of the text fields, say VARCHAR(MAX). But, neither of these is good data types for storing within SQL Server. For binary files, I generally recommend just storing them in the file system. It does a better job than a database for managing files.