You use SQL Server to maintain the data used by applications at your company. You need to run two separate SQL statement
Posted: Mon Oct 17, 2022 4:50 pm
You use SQL Server to maintain the data used by applications at your company.
You need to run two separate SQL statements.
You must guarantee that the following three things happen:
Either BOTH statements succeed or BOTH statements fail as a batch.
✑ If an error occurs on the first statement, SQL should not attempt to run the second statement.
✑ Error information should be returned to the client.
What should you do?
A. Option A
B. Option B
C. Option C
D. Option D
You need to run two separate SQL statements.
You must guarantee that the following three things happen:
Either BOTH statements succeed or BOTH statements fail as a batch.
✑ If an error occurs on the first statement, SQL should not attempt to run the second statement.
✑ Error information should be returned to the client.
What should you do?
- You Use Sql Ser 1 (116 Bytes) Viewed 109 times
- You Use Sql Ser 2 (35.41 KiB) Viewed 109 times
B. Option B
C. Option C
D. Option D