SSMS结果为可点击的链接 [英] SSMS results as a clickable link

问题描述

我对SQL还是很陌生，我四处看看是否可以找到一种可行的方法

I am fairly new to SQL and I have looked around to see if i could find a way to do this if it is possible

这是我的SQL查询文本:

Here is my SQL query text:

SELECT *, 
CONCAT('https://domain:8080/analyzer?sipid=',SIPCallId,'&cmd=GetAnswerWAV') 'FaxScope: Inbound Audio (WAV) Link',

结果:

https://domain:8080/analyzer?sipid = b38f9368905856 -0084-7302& cmd = GetAnswerWAV

在SQL查询结果中，我必须将URL复制/粘贴到Web浏览器中以获取此链接应提供的数据.

In the SQL Query results, I have to copy/paste the url into a web browser to get the data this link should provide.

是否可能使SQL结果本身成为可点击的链接?

Is this possible to have the SQL result be a clickable link itself?

推荐答案

虽然我不确定是否可以将结果窗口推送到浏览器窗口，但是您可以将查询结果声明为.这会将URL推送到查询窗口中的新会话中，您应该可以从中 ctrl +单击进入嵌入式SSMS浏览器.

While I'm not certain if it's possible to have the results window push through to a browser window, you can declare the result of your query to be 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.

declare @url varchar( 255 )

select @url = 'http://www.google.com' -- your query here

select @url for xml path

这篇关于SSMS结果为可点击的链接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！