Answer / themba tjnas ngobeni

Hi, If you already know what record to pick then before
recommend what you need to do:

1. do you know how your table structure looks like? I guess
u know but do you have indexes build on your major select
columns?

2. irrespective of how many columns are there if you know
how to describe your table you will know which columns are
of importance to you.

With that I will recommend this:

Write your sql statement similar to:
1. Select *
From My_table
where major_column = :my_value --Primary key view all
columns

2. Select *
From My_table
limit 1 -- without primary key but view all columns

3. Select my_column1,my_column2,my_column3, etc
From My_table
where my_column1 like '%:my_value%' -- without using
primary key
limit 1

you can still write more sql statements to achieve the same
results if you want to be vendor specific like Oracle you
can use limit 1 or rownum =1 etc.

I hope this answers you questions.
Regards

How to integrate automated scripts from testdirector to winrunner scripts?

0 Answers  

---

How winrunner Handles varying window Labels?

2 Answers   FCG,

---

What Is Test policy and what is Test Strategy ? differenciate between them? Explain with examples?

5 Answers   Accenture,

---

tell me about compiled module & function generator

5 Answers   CTS,

---

How you integrated your automated scripts from TestDirector?

0 Answers  

---

is 'tech' is a Reserved word in WinRunner or not?

1 Answers   FCG,

---

What is the different types of Data driven testing?

2 Answers   Synergy,

---

How will u find Automation Test cases and how to find regression test cases?

4 Answers   TCS,

---

What is the purpose of Wdiff utility?

1 Answers  

---

Which function to use to compare the application date with system date?

0 Answers  

---

What is the purpose of a gui spy?

0 Answers  

---

What is the exact difference between Integration & System testing, give me examples with your project.

5 Answers   Accenture,

---