DBI 411 Integrating SQL Server File Tables Property
DBI 411 Integrating SQL Server File. Tables, Property Search, and FTS/Semantic Search Bob Beauchemin Developer Skills Partner SQLskills
bobb@sqlskills. com www. sqlskills. com /blogs/bobb Bob Beauchemin @bobbeauch
\machinesharedbdirectoryftdirectory
Name Type Description path_locator parent_path_locator hierarchyid Position of this node in the hierarchical file namespace. Hierarchy. ID of the parent directory (computed column) stream_id file_stream file_type uniqueidentifier varbinary(max) filestream nvarchar(255) Unique Id for Filestream data Type of the file. Usable for full-text index cached_file_size bigint Size of the filestream(cached value) name creation_time last_write_time last_access_time is_directory is_offline is_hidden is_readonly is_archive is_system is_temporary nvarchar(255) datetime 2 bit bit File/Folder Name Creation Time Last. Write. Time Last. Access. Time TRUE for directories. Offline attribute Hidden attribute Read Only attribute Archive attribute System attribute Temporary attribute
http: //www. sqlskills. com/BLOGS/BOBB/post/SQL-Server-2012 File. Tables-in-T-SQL-part-1 -functions-and-methods. aspx
SQL Server 2012 Eval Copy Hands-On Labs mva Microsoft Virtual Academy Get Certified! @sqlserver @ms_teched
Learning Connect. Share. Discuss. Microsoft Certification & Training Resources http: //europe. msteched. com www. microsoft. com/learning Tech. Net Resources for IT Professionals Resources for Developers http: //microsoft. com/technet http: //microsoft. com/msdn
Evaluations Submit your evals online http: //europe. msteched. com/sessions
- Slides: 36