Hyperlink Datatype in SQL Server?!

Dear All,

I just want to know ,wheather there is any way to store 'hyperlink' in sql Table as in Ms Access.

or

What is the Procedure to store a Path of a file in SQL table and file should be able to retrieve through the query.

Thhank you

Graceson MathewI think that you will find that what you are asking for is a mix of back-end storage and front-end (client) formatting. Access really blurs the line between these two (very different) functions. SQL Server, on the other hand, is clearly a back-end storage system (ie, minimal client-side formatting features).

What you will end up having to do is to store text values for URLs and/or file locations and then use a client-side script/program/tool to format the data for presentation.

I personally like to pull the data using an ADO stream formatted in XML and then transform it with an XSL template. It's fast (as long as the recordsets aren't too big), it's flexible and gives you a great deal of control over how the data is represented.

This is not, however, the only solution.

Regards,

hmscott

Dear All,

I just want to know ,wheather there is any way to store 'hyperlink' in sql Table as in Ms Access.

or

What is the Procedure to store a Path of a file in SQL table and file should be able to retrieve through the query.

Thhank you

Graceson Mathew