I have managed, installed and troubleshooted MS SQL DB but i have never programmed for it. Now I may have to start.
To make things more manageable I am using MS Access as my front end GUI.
1. Is it possible for me to take a PDF and submit it into SQL DB, have it stored and cataloged with some title. Then later if needed to recall it from SQL DB? If so what do I need to do for this to work?
2. Should I create all the tables in the back endthat I need or go and do them as I go along when I need them
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…