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

Arvind Yadav

4y1.2kSQL

Can we upload PDF files into SQL without using any programing language?

(using only SQL query if yes please share script)

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gajendra Jangid4y ago
https://www.mssqltips.com/sqlservertip/1207/different-options-for-importing-data-into-sql-server/
+2
Sachin Singh4y ago
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
+2
Arnab Mukherjee4y ago
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
+2