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 file extension for object in AUT captured by WR

1 Answers  

---

what is mean SRS and URS . differns btwn SRS and URS

3 Answers  

---

please tell me how to explain the project by taking any project (like banking product), how to start explaing?what will be the order of priority e.g.,like purpose, modules, HLDs LLDs etc., in testing point of view (as a testengineer). rightnow i can't explain my project though i've done successfully..so plz help me ..

9 Answers   HCL, IBM, ITC Infotech, Raisoni, TCS, Wipro,

---

what is the name given by WR to Microsoft excel file

2 Answers  

---

how do to stop the functionality of UDF

1 Answers  

---

What is checkpoints?

1 Answers  

---

How many types of tests can u create in winrunner?

2 Answers   Covansys,

---

can anybody tell me about 5 critical,major & low severity and priority with examples.

0 Answers  

---

Is Gui Map Created when you record in Analog mode?

2 Answers   Second Foundation,

---

What is the use of gui map and what happens when the gui map file get loaded?

0 Answers  

---

kindly provide me test cases on browser and calculator.Its very urgent.

0 Answers   TCS,

---

write a compilemodule function for loginscreen.

0 Answers  

---