Can we upload PDF file into SQL without using any programing language

Question

Can we upload PDF files into SQL without using any programing language? (using only SQL query if yes please share script)

Sachin Singh · Answer

yes, CREATE TABLE [tblPDF]( [Id] [ int ] IDENTITY(1,1) NOT NULL, [Data] [varbinary](max) NULL CONSTRAINT [PK_Thumbnail] PRIMARY KEY CLUSTERED ( [Id] ASC ) ) ON [PRIMARY] SELECT * FROM OPENROWSET (BULK 'C:\Folder1\myPdf.pdf' , SINGLE_BLOB) AS X INSERT [ tblPDF ] ( Data ) SELECT * FROM OPENROWSET (BULK ' C:\Folder1\myPdf.pdf ' , SINGLE_BLOB) AS X

Arnab Mukherjee · Answer

Sample Table : CREATE TABLE [dbo].[tbl_Test]( [ID] [int] IDENTITY(1,1) NOT NULL, [PDF_File] [varbinary](max) NULL, CONSTRAINT [PK_tbl_Test] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO Insert PDF Files : INSERT INTO TBL_TEST (PDF_FILE) SELECT * FROM OPENROWSET(BULK N'Put the file path here', SINGLE_BLOB) AS BLOB INSERT INTO TBL_TEST (PDF_FILE) SELECT * FROM OPENROWSET(BULK N'C:\Downloads\SampleFile.PDF', SINGLE_BLOB) AS BLOB Show the record : SELECT * FROM TBL_TEST Hope it will help you, Thanks

Gajendra Jangid · Answer

https://www.mssqltips.com/sqlservertip/1207/different-options-for-importing-data-into-sql-server/