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

what is the tsl statement for selecting the position of item in list box in winrunner?

4 Answers   MBT,

---

In an Interview on person asked me about WR frame work. in what way i have to explain and what is the answer?

2 Answers   Stag Computers,

---

How to fetch a value which is in a particular cell in a html table?

1 Answers   BeBo Technologies,

---

what r the standard properties r u checking for pushbutton?

1 Answers   MBT,

---

what is software metrics

1 Answers   IBM,

---

what is the file extension for object in AUT captured by WR

1 Answers  

---

What is the diffrance bet. Compiled module and User defined Functions?

5 Answers  

---

How do you create a new expected results in winrunner?

1 Answers   Accenture,

---

what is mean by test coverage?

1 Answers  

---

how u can do parameterization in winrunner? tell me the sample code.

2 Answers   Mastek, MBT,

---

How you integrated your automated scripts from TestDirector?

0 Answers  

---

Can any one plz tell me any site where i could find some free testing tools like winrunner,load runner etc.plz reply on my mail if possible.Regards nitin9360@gmail.com

1 Answers  

---