When a C program is written using Embedded SQL, (e.g.: assume that a table is created with values inserted into it), how it gets executed in the back-end before displaying the output table in the front-end?
This question may seem theoretical but can anyone help me get an answer?
Assuming your C program is Visual C and you are using .NET libraries:
- Establish a connection using SQLConnection
- Open the connection
- Build a SQLCommand object on the connection
- Point the SQLCommand to your query string
- Execute the SqlCommand
- Process the results.