3
Answers

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

Photo of Arvind Yadav

Arvind Yadav
3y
917
1

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

(using only SQL query if yes please share script)

Answers (3)

3
Photo of Sachin Singh
NA 55.8k 88.4k 3y
yes,
  1. CREATE TABLE [tblPDF](  
  2.    [Id]        [int] IDENTITY(1,1) NOT NULL,  
  3.    [Data]      [varbinary](max) NULL  
  4. CONSTRAINT [PK_Thumbnail] PRIMARY KEY CLUSTERED   
  5. (  
  6. [Id] ASC  
  7. ) ) ON [PRIMARY]  
  1. SELECT * FROM OPENROWSET (BULK 'C:\Folder1\myPdf.pdf', SINGLE_BLOB) AS X  
  2. INSERT [tblPDF] ( Data ) SELECT * FROM OPENROWSET (BULK 'C:\Folder1\myPdf.pdf', SINGLE_BLOB) AS X
 
3
Photo of Arnab Mukherjee
439 3.1k 162.5k 3y
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
Photo of Gajendra Jangid
25 41.2k 2.3m 3y
https://www.mssqltips.com/sqlservertip/1207/different-options-for-importing-data-into-sql-server/
 
Next Recommended Forum