Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    India
    Posts
    56

    Unanswered: 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 Mathew

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    I 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


    Quote Originally Posted by graceson
    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
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •