URL (hyperlink) in SQL server table

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
rmtogetherAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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..
0
rmtogetherAuthor Commented:
so it can't be both "value" and "hyperlink value" am I correct?
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Yes.. You can store Hyperlink in one column and data in another column and not in a single column..
0
rmtogetherAuthor Commented:
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.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> like create a table and one column is hyperlink data-type

Let me explain it more clear..
You don't have hyperlink datatype available and what I mentioned was to save the link in a varchar column like 'www.experts-exchange.com'

And a simple example for this would be:

create table test ( ID int , value int, hyperlink varchar(1000))
insert into test (ID, value, hyperlink )
values ( 1, 10, 'www.xyz.com')
insert into test (ID, value, hyperlink )
values ( 2, 20, 'C:\test_folder\test_file.txt')
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.