<div>
Then you need to store the hyperlink value ( html tag value) instead of value in your table..<br />
Instead of storing the hyperlink in the manner you have requested, try storing the file location of the excel file..
</div>


Then you need to store the hyperlink value ( html tag value) instead of value in your table..
Instead of storing the hyperlink in the manner you have requested, try storing the file location of the excel file..

<div>
so it can't be both &quot;value&quot; and &quot;hyperlink value&quot; am I correct?
</div>


so it can't be both "value" and "hyperlink value" am I correct?

<div>
Yes.. You can store Hyperlink in one column and data in another column and not in a single column..
</div>


Yes.. You can store Hyperlink in one column and data in another column and not in a single column..

<div>
could you give me a simple example to do this<br />
<br />
like create a table and one column is hyperlink data-type and &nbsp;an insert statement<br />
<br />
thanks.
</div>


could you give me a simple example to do this

like create a table and one column is hyperlink data-type and  an insert statement

thanks.

<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
Is it possible to make a URL in the return table in SQL server 2008<br />
<br />
for example, in my case<br />
<br />
I import excel data in to SQL server. and this is the result from select statement<br />
<br />
&lt;return table&gt;<br />
ID value<br />
1 &nbsp; 10<br />
2 &nbsp; &nbsp;20<br />
3 &nbsp; &nbsp;5<br />
<br />
if I want to look back to my excel file, can I make a hyperlink possible in this kind of table.<br />
&nbsp;for example, make value 10 is both value and hyperlink, when I click &quot;10&quot; it will open the original excel file that I import from (e.g D:\sample.xls) or it can only be a separate column contains the hyperlink<br />
<br />
Please teach me if it is possible and how to do it. thanks in advance
</div>
</div>


Hi, 

Is it possible to make a URL in the return table in SQL server 2008

for example, in my case

I import excel data in to SQL server. and this is the result from select statement

<return table>
ID value
1   10
2    20
3    5

if I want to look back to my excel file, can I make a hyperlink possible in this kind of table.
 for example, make value 10 is both value and hyperlink, when I click "10" it will open the original excel file that I import from (e.g D:\sample.xls) or it can only be a separate column contains the hyperlink

Please teach me if it is possible and how to do it. thanks in advance

URL (hyperlink) in SQL server table

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.