将文件存储在SQL Server上 [英] Store files on SQL server

问题描述

美好的一天



我想找到一种方法能够在SQL Server上存储文件

SQL数据库存储文件名和路径

文件驻留在服务器上

用户可以登录到SQL Server并检索文件

我做不希望将文件存储为字段中的字节

所以希望能够连接到SQL Server - 发送和接收字节文件信息

但是字节信息作为SQL Server上的文件保存回来



我尝试过：



已经研究了一段时间 - 在一个阶段我确实找到了一篇文章，在SQL Express 2014中这可能已经完成，我遗憾地丢失了文章，但从未经历过它以确保它可以完成？研究过TCP IP示例 - 但是一个已经在使用SQL - 创建双系统？不太确定这是否是从服务器加载和检索文件并让SQL数据库管理它的正确方法？

Good Day

I am trying to figure out a way to be able to store files on a SQL Server
SQL database to store the file name and path
File to reside on the Server
User to be able to Login to SQL Server and Retrieve File
I Do not want to store files as Byte(s) in a Field
So want to be able to connect to SQL Server - Send and receive Byte file information
But the Byte info to be saved back as a file on the SQL Server

What I have tried:

Have researched this for a while - at one stage i did find an article that in SQL Express 2014 that this could be Done, I sadly lost the article but never went through it to be sure that it could be done? Have researched TCP IP examples - but is one is already using SQL - creates a dual system? Not too sure if this would be the correct approach to load and retrieve files from a server and let the SQL database manage it?

推荐答案

好像你正在寻找< a href =https://docs.microsoft.com/en-us/sql/relational-databases/blob/filestream-sql-server?view=sql-server-2017> FILESTREAM（SQL Server）| Microsoft Docs [ ^ ]。

Seems like you are looking for FILESTREAM (SQL Server) | Microsoft Docs[^].

这篇关于将文件存储在SQL Server上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！