How I can use SQLQuery to retrieve table data from database.
How I can use SQLQuery to retrieve table data from database using stored procedure which will insert data in database and then return table data.
Posted: 2 years ago
Posted: 2 years ago
Thanks Sudhakar.
Can I see an exmple to know how i can achieve this.
Hi,
If you are planning to retrieve the data from multiple tables and writing the logic in stored procedure to do that, you can RDB methods to retrieve the data.
Use Connect SQL rules when your application needs to run complex Structured Query Language statements such as joins or stored procedures to update or extract information from an external database.