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 are virtual object configured

1 Answers  

---

What do you verify with the gui checkpoint for single property and what command it generates, explain syntax?

0 Answers  

---

pls write test case for google and yahoo mail page. pls any body known the answer immediatly post the answer

1 Answers   Calsoft,

---

How to Know through script which add-ins are loaded with winrunner?

2 Answers   Accenture,

---

What do you verify with the sync point for object/window bitmap and what command it generates, explain syntax?

0 Answers  

---

---

what is the difference between unit testing,integration testing and interface testing?

4 Answers  

---

What is the process of file parsing in winrunner?

1 Answers  

---

hi all this is srivalli i had completed my b.e in 2005, i want to learn testing.so anybody plz hep mi wat'll b thr in testing n which is da best institute n how r da job opprtunities right now coz ppl r telling mi thr is sum down trend in sw now, so how much it is appropriate 2 take da course now. thankz in aadv

4 Answers  

---

What is the XML test cases creation?

0 Answers   IBM,

---

The title of the window consists of Date and Time.Tell me the Regular Expression to recognise that window as unique?

1 Answers   FCG,

---

Hai guys can any one tell me tnhe difference between the product testing and Project testing?

2 Answers  

---

what is the difference between bitmap checkpoint and image checkpoint

1 Answers   Ness Technologies,

---