Explain how to store pdf file in SQL server.- Following are the steps of creating a pdf file in SQL server:
1. Create a column as type 'blob' in a table. 2. Read the content of the file. 3. Save in 'blob' type column in a table or store them in a folder and establish the pointer to link them in the database.
- To retrieve the file from the database, SELECT query is executed and ID of the file is passed as an argument.
|