如何使用 TSQL 将文件上传到 SQL Server 2008 中的 varbinary(max) 列？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1800036/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How do I upload a file to a varbinary(max) column in SQL Server 2008, using TSQL?
提问by chum of chance
This must be possible because I believe I've done it before. Here's my query:
这一定是可能的，因为我相信我以前做过。这是我的查询：
insert into exampleFiles Values(NEWID(), cast('c:\filename.zip' as varbinary(max))
Obviously that just inserts the text in between the quotes and not the file from that location. There must be a simple tsql bit of language that I'm forgetting. Thanks
显然，这只是在引号之间插入文本，而不是该位置的文件。一定有我忘记的简单的 tsql 语言位。谢谢
回答by dcp
Does this help?
这有帮助吗？
USE AdventureWorks
GO
CREATE TABLE myTable(FileName nvarchar(60),
FileType nvarchar(60), Document varbinary(max))
GO
INSERT INTO myTable(FileName, FileType, field_varbinary)
SELECT 'Text1.txt' AS FileName,
'.txt' AS FileType,
* FROM OPENROWSET(BULK N'C:\Text1.txt', SINGLE_BLOB) AS Document
GO
Taken from here: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/513cbf8c-21a8-4bcc-a565-6eb06437a398
取自这里：http: //social.msdn.microsoft.com/Forums/en-US/sqltools/thread/513cbf8c-21a8-4bcc-a565-6eb06437a398
