Table with hyperlink

Question

Table with hyperlink

paulina.leicht

SSC Enthusiast

Points: 199
More actions
September 25, 2018 at 6:46 am

#363493

How to display all table with hyperlink and the hyperlink should be clickable?

ID TYPE LINK
1 A http://www.google.com
2 B http://www.yahoo.com
Thanks in advance

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

drew.allen SSC Guru Points: 76997 More actions · Answer 1

That depends on what UI you are using to display the data. Since you didn't state, I'm assuming you mean in SSMS. SSMS is a development environment, and is not meant to be used as a UI, so it does not support this functionality.

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

sgmunson SSC Guru Points: 110640 More actions · Answer 2

paulina.leicht - Tuesday, September 25, 2018 6:46 AM
How to display all table with hyperlink and the hyperlink should be clickable?

ID TYPE LINK
1 A http://www.google.com
2 B http://www.yahoo.com
Thanks in advance

Drew is correct. SQL Server Management Studio (aka SSMS) isn't going to be able to provide that functionality. You would need to be able to run your query from an application: whether it's a web page app, an Excel spreadsheet that uses VBA code, or an Access database that displays the links on a form, or your own desktop program created with Visual Studio and .Net.

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

Jason A. Long SSC-Insane Points: 23786 More actions · Answer 3

If you convert the URL to XML and squint really hard, you actually can get a working hyperlink in SSMS... Sort of...

SELECT CONVERT(XML, 'https://www.sqlservercentral.com/Forums/1997095/Table-with-hyperlink')

This will generate an XML link, that will produce a clickable value in the grid view. Clicking that will open a new tab with a clickable URL hyperlink.
It's not even remotely elegant but it does work.

paulina.leicht SSC Enthusiast Points: 199 More actions · Answer 4

1. I found such a solution but still I don't know how to display all table

declare @url varchar( 255 )select @url = 'http://www.google.com' -- your query hereselect @url for xml path

this will push the URL into a new session in the query window from which you should be able to ctrl+click through to the embedded SSMS browser.

2. How can I save a link due to open it as a hyperlink in excel?

usererror Ten Centuries Points: 1148 More actions · Answer 5

Are you trying to copy query results from the SSMS Results Grid and then paste them into an excel workbook? Are you wanting the pasted results to retain the hyperlink in Excel?

-Mark
MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.