# How to upload pdf file to sql sever

**URL:** <https://discourse.nodered.org/t/how-to-upload-pdf-file-to-sql-sever/58886>\
**Category:** General\
**Tags:** database\
**Created:** [23 February 2022 15:30 UTC](https://discourse.nodered.org/t/how-to-upload-pdf-file-to-sql-sever/58886 "2022-02-23T15:30:38Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![chawana](https://avatars.discourse-cdn.com/v4/letter/c/ecccb3/32.png) [@chawana](https://discourse.nodered.org/u/chawana)\
**Post date:** [24 February 2022 03:20 UTC](https://discourse.nodered.org/t/how-to-upload-pdf-file-to-sql-sever/58886/4 "2022-02-24T03:20:28Z")

</div>

[quote="Steve-Mcl, post:3, topic:58886"]

- Do you have the "Upload" part working?  
ํYes,
- Do you have the SQL Server `INSERT` part working?  
Yes, using node red.
- Do you have the Database and its Tables created already?  
No, please recommend data type.
- Are you expecting to use SQL Stored Procedures or INSERT queries?  
Just INSERT queries.
- Are you wanting to upload the text from the PDF (into a text field) OR the actual file (as a blob?)actual file .pdf  
what SQL Server version are you using?ver 2014 express.
- is the SQL Server local or remote: Local
- are you using built-in security or SQL Server logins? No need
- Are you using `node-red-contrib-mssql-plus` (this is the most capable / most supported node)  
Yes using node mssql-plus.

Thanks

---

_[View the full topic](https://discourse.nodered.org/t/how-to-upload-pdf-file-to-sql-sever/58886)._