使用BCP命令在SQL数据库中上传文件

你可以试试这个

SET @TableQuery='CREATE TABLE [temp1](
           [Id] [int] IDENTITY(1,1) NOT NULL,
           Project [NVARCHAR(50)], 
           SubProject [NVARCHAR(50)], 
           LogicalName [NVARCHAR(50)],
           FileName [NVARCHAR(50)], 
           FileData [NVARCHAR(50)],
           CONSTRAINT [PK_temp1] PRIMARY KEY CLUSTERED 
           (
              [Id] ASC
            )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
            ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
                                              '
           EXEC(@TableQuery)  

           DECLARE @params NVARCHAR(max)
           SET @params = N'@uploadData SINGLE_BLOB readonly'

           SET @BulkInsertQuery =N'INSERT INTO [temp1] ( Project,            SubProject,LogicalName,FileName,FileData) 
select * from @uploadData';          
           print @BulkInsertQuery
           EXEC sp_executesql @BulkInsertQuery, @params, @uploadData

  // Enter Records from temp table into real table

           INSERT INTO ExcelFileUploadedData(
              Project, 
              SubProject, 
              LogicalName,FileName, 
              FileData) 
           SELECT 
              'Sample',
              'Sample',
              'BP',
              '1.xls',
              * 
       FROM [temp1]