SQL inserts a local picture file into the database

EXECsp_configure'Show advanced Options',1GORECONFIGUREGOEXECsp_configure'xp_cmdshell',1GORECONFIGUREGO--generate a format file and edit it on this basis, it's a bit problematic to create a format file yourself--10.0--1--1 sqlbinary 0 0 "" 1 FileData ""--CREATE TABLE [dbo]. [Tblfile] (--[FileID] [bigint] IDENTITY () not NULL,--[FileData] [varbinary] (max) not NULL--)  --file Import to databaseINSERT  intoDbo.t_image (Image)SELECT *  from OPENROWSET(BULKN'E:\pic.jpg', Single_blob) asDocument----Export binary to file from database--DECLARE @CmdQuery as VARCHAR (+)--SET @CmdQuery = ' bcp ' Select image from TestDB.dbo.t_image "queryout" C:\a.cs "-t-f" C:\BCP Currency.dat "'--EXEC Master. xp_cmdshell @CmdQuery

SQL inserts a local picture file into the database