Incorporating a database in industrial programming allows for data retention and access. If the database is placed on the corporation server, back-up can be established by the IT department.
Some of these examples will be on a local machine, such as a desktop or a laptop.
Ensure the development machine has the following software installed.
- Microsoft SQL Server, Enterprise or Development edition
- Microsoft SQL Server Management Studio
Downloads
SQL Server Database: https://www.microsoft.com/en-us/sql-server/sql-server-downloads
Management Studio: https://www.microsoft.com/en-us/Download/details.aspx?id=101064
The following posts will review how to accomplish the following.
- Create a table
- Establish a primary key
- Establish a foreign key
- Character variable
- Integer variable
- Bit variable – Logical
- Float – Real Number
- Database communication
Note that my intent on this site is not to dwell on the abilities of SQL database commands and explanations, but to focus on extracting data for industrial applications. The following site(s) are good references for using SQL commands.