Sunday, February 19, 2012

Hyperlink

Is it possible to store an email address as a hyperlink in SQL Server table?
ThanksNo, there is not a hyperlink data type in SQL. You will have to store the
value as a different data type and do the programming on the front end
application to use it as a hyperlink. I would suggest varchar, but I am
fairly new to SQL and there may be a better data type.
"Brennan" wrote:
> Is it possible to store an email address as a hyperlink in SQL Server table?
> Thanks|||You can store the email address as character data in SQL Server. However,
hyperlink functionality (launch email client or browser) is a function of
the front-end application, not the relational database. For example, if you
are rendering data in html, you could enclose the email address in an anchor
tag:
<a href="http://links.10026.com/?link=mailto:me@.mydomain.com">me@.mydomain.com</a>
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Brennan" <Brennan@.discussions.microsoft.com> wrote in message
news:879832D4-68A3-4500-9410-D424A19C7EBC@.microsoft.com...
> Is it possible to store an email address as a hyperlink in SQL Server
> table?
> Thanks

No comments:

Post a Comment