Is it possible to create a hyperlink column in a SQL Server table? I was hoping to create a column which appears as Y but links through to a website like a normal hyperlink.
I created a test table as follows:
USE MIProcessing
CREATE TABLE Test
(Hyperlink nvarchar(255),
);
I then tried to use HTML code within an INSERT INTO statement to add the hyperlink.
The problem with it is that the Presentation layer will usually also be responsible for the CSS Style / Class, and all sorts of other "presentation" <Natch!> issues which you don't really want to have to adjust, and re-dploy, the SQL code when they need changing.
If you use HTML Templates in your code then you can probably write something like
Please click <a href="{HyperLink}">{TextLink}</a> to continue