sql 2008中有关hyberlink数据类型的信息 [英] about hyberlink datatype in the sql 2008

问题描述

嗨
任何人都可以帮我解决sql 2008哪个数据类型可以用于超链接字段我找不到的问题吗?
谢谢

Hi
any one can you help me for sql 2008 which datatype is can use to hyperlink Field i can''t find
Thanks

推荐答案

您可以利用新的 FileStream 功能，该功能允许您存储二进制大对象(BLOB)数据作为文件系统上的文件，而不会破坏与行的联系.此外，备份和复制过程也支持 FileStream .

以下链接将为您提供帮助:

SQL Server 2008(ADO.NET)中的文件流数据
FileStream数据类型:SQL Server 2008
使用SQL Server 2008进行牵引Filestream

You could leverage the new FileStream feature that allows you to store binary large object (BLOB) data as files on the file system without breaking the bond with the row. Moreover, FileStream is also supported by backup and replication processes.

The following links will help you:

FILESTREAM Data in SQL Server 2008 (ADO.NET)
FileStream Data Type : SQL Server 2008
Getting Traction with SQL Server 2008 Filestream

SQL Server中没有超链接数据类型.超链接基本上只是文本，并且用户界面具有识别/显示/向该文本添加功能的能力(例如打开链接等).

根据您的需求，您可以使用 nvarchar [ xml [

There''s no hyperlink data type in SQL Server. Hyperlink is basically just text and the user interface has the capability to recognize/show/add functionality to this text (such as open the link etc).

Depending on your needs you could use either nvarchar[^] or xml[^] to store the hyperlink (data portion).

这篇关于sql 2008中有关hyberlink数据类型的信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！