Find Record and display its values

Question

User-1499457942 posted

Hi

  I am reading data from Master table and want to find record in Transaction table and display its values . It should return only 1 record . If more than 1 it should display error message. What is the best and fastest way

Thank

Answer 1

User839733648 posted

Hi JagjitSingh ,

The way to read data from database is related to your actual demand.

I suggest that you could use Stored Procedure.

When you use this, you just need to pass parameters. The other operations are completed inside.

This is a more effective and recommended way.

More information, you could refer below link:

https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/create-a-stored-procedure?view=sql-server-2017 

https://www.w3schools.com/sql/sql_stored_procedures.asp 

Best Regards,
Jenifer