Interested to Buy Any Domain ? << Click Here >> for more details...
Hi guys pls any one help me , I am facing this problem since
last one week ,
my question is
in there 1000 rows and 1000 coloums , i want to pick the one
record , how ?
- 1 Answers
- 4773 Views
- I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 2 Yes | 2 No |
which testcases do u automate?
what is the purpose of '*', '&','.' symbols in Regular Expressions (winrunner)?
How do you that one record was entered in to a particular table using winrunner?
which option in WR executes the script line by line
How do you create a startup script in winrunner and what is consists generally?
What are the advantages of Global gui over gui map per test mode?
How do u identify the object that it is a standard object or not
How enviornment veriable can be included into my script. I want to include some information into my Excel file using Test run in WR. like User name of system? waht is function to be used? Please clarify.....
0 Answers Google, Malhotra Associates, Seed Infotech,
you hae a inbox and got a mail how can you know it is there or not write script.
Where did you learn winrunner and testdirector?
How we conduct Regression Testing through WinRunner
which function executes multiple TSL script
WinRunner 
