There's no hyperlink data type in SQL Server. Hyperlink is basically just text and the user interface has the capability to recognize/show/add functionality to this text (such as open the link etc).
Depending on your needs you could use either
nvarchar[
^] or
xml[
^] to store the hyperlink (data portion).