使用SQL INSERT通过FileTable创建目录

问题描述

有没有一种方法可以在 FileTable 中创建目录文件I/O API?它与创建SQL INSERT语句一样简单吗?

Is there a way to create directories in a FileTable without using File I/O APIs? Is it just as simple as creating a SQL INSERT statement?

这是我第一次使用SQL Server 2012，我对SQL Server中FileTable的限制不熟悉.

This is my first experience with SQL Server 2012 and I'm not familiar with the limits of the FileTable from within SQL Server.

推荐答案

以下内容对我有用.希望这可以帮助其他人.

The following worked for me. Hopefully this helps out someone else.

INSERT INTO FileTable0 (name,is_directory,is_archive) VALUES ('Directory', 1, 0);

• 您还应该查看 Bob Beauchemin的Techdays 2012视频，以了解更多详细信息在FileStream上并演变为FileTable.
• You should also check out Bob Beauchemin's Techdays 2012 video for more details on FileStream and its evolution into FileTable.

这篇关于使用SQL INSERT通过FileTable创建目录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！