Which SQL Data Type can accommodate links

Question

Which SQL data types can I use to accommodate links like www.google.com?

Which SQL data type can I use to store html codes?

<a href="www.google.com">Google</a>

I would like to store my links in the database, to use a for loop to automatically populate he links.

Answer 1

Any of the string data types (e.g. varchar, nvarchar, etc) can accomodate the href attributes from links. And another string column can accommodate the inner text. So something like:

CREATE TABLE T (
    --Various columns
    LinkHref nvarchar(max) not null,
    LinkBody nvarchar(max) not null
)

Then, construct the surrounding anchor tag when you're extracting them for display. This also makes the links more searchable in the database in the future.