It is desirable to display a database text column as HTML. This would enable content management. Currently, database text columns display as plain text including HTML markup. I created this table which could support simple content management - column content_block_text could contain HTML.
CREATE TABLE dbo.content_block (
content_block_code varchar(60) NOT NULL,
content_block_text nvarchar(max) NOT NULL,
infosys_code varchar(60) NULL,
insert_user varchar(60) NOT NULL,
last_update_user varchar(60) NULL ,
delete_user varchar(60) NULL ,
insert_date datetime NULL DEFAULT getdate(),
last_update_date datetime NULL,
delete_date datetime NULL
)
GO
ALTER TABLE dbo.content_block
ADD CONSTRAINT PK_content_block_01 PRIMARY KEY (content_block_code)
GO