Post reply

Table with hyperlink

  • 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

  • September 25, 2018 at 7:41 am

    #2006894

    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

  • September 25, 2018 at 8:29 am

    #2006906

    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)?:) 🙂 :)?
    Health & Nutrition
    Rent Servers for Income (picks and shovels strategy)

  • September 25, 2018 at 9:51 am

    #2006938

    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://qa.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.

  • September 26, 2018 at 12:09 am

    #2007043

    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?

  • September 26, 2018 at 7:20 am

    #2007072

    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.

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

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