Forum Discussion

New Contributor

3 years ago

Solved

Compare two SQL query results data

Hi, Is there any way to compare two SQL queries data in TestComplete through Database checkpoint? For ex: SQL query 1 - DBTable1 SQL query 2 - DBTable 2 and then compare --> DBTable1 vs DBTa...

Marsha_R
3 years ago
https://support.smartbear.com/testcomplete/docs/testing-with/checkpoints/database/creating.html#SpecifyBaselinedatabaseTable

Creating the table entry for comparison would be a manual process and if your tables change frequently, that's not the best way to go. If the file compare is doing what you need, then I would stick with that.

Occasional Contributor

3 years ago

You can do the comparison by using the two queries together and using the minus operator of SQL. Look up "minus" - it's pretty cool...

Related Content

Compare two SQL query results
5 years agobach_ls
Comparing table data in IF not working
9 months agoLuukdb
Query to monitor result,
11 years agovwanaskar
Re: Comparing JDBC results
7 years agoalexis733
How to compare images?
12 months agoclaudio

Recent Discussions

Connecting to license manager behind a home router?
Solved
13 hours agotramuntana
How to specify to not save Pictures into log files for some actions
Solved
13 hours agosimonaferrara
Log.Error supressing Log.Warning in Execution Summary
2 days agoRodm00011
TC15 Log Details shows # of tests with warnings/errors, not TC14's # of warnings/errors
2 days agothebick
Change the OS region format all at once
Solved
3 days agoSlickRick