There r 1000 rows and 1000 coloums , in that I want pickup a
name of the coloumn , pls dont say in sql statements , in
interview one of the interviewer said it was a wrong answer
pls any send me answer its urgent
Answer Posted / ashok kumar
src = "DRIVER=SQL Server;SERVER=<ur
server>;UID=<username>;PWD=<password>;DATABASE=<database>"
Set dbconn = CreateObject("ADODB.Connection")
dbconn.Open src
Set dbrecset = dbconn.Execute(query to connect table)
For i = 0 to dbrecset.Fields.Count-1 'to get total col. count
Print dbrecset.Fields(i).Name 'to print col. name
Next
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
what is keyword driven testing in qtp?n how is it useful?
Through array we can execute the testcase how ? give me example
i need to add 1000 users in a domain i written the script for that and it is running successfuly but the problem is that my system is not the user of that domain in which i have to add users so for adding users in that domain i have to install qtp on that another system, can anybody suggest me the way to add those users from my system ultimately i want to know how to access remote computer through script
Please Don't mind .i want in detail the real time process i.e in each document what it contains.
Hi iam shankar here, right now iam working on manual testing. i want to switch over automation tool qtp, right now iam taking training class outside on qtp, please let me know the cost of QTP tool for full version, wether it's an annual subscription or monthly subscription.
Tell me one scenario, the complex functionality you have automated in your project?
How many types of recording modes in qtp?
PLEASE TELL ME WHEN DO YOU USE THE OBJECT SPY AT RUN TIME
Dear All , For UFT 12.02 which version QC or ALM will support ? Thanks Balaji
Is there any pdf or online book for QTP Scripting? Let me know more about QTP Scripting.
How to carry out bit map check points in QTP
What is the descriptive programming?
Suppose I have three hyperlinks with same properties. How to solve this and what are the ways to solve this. we can solve this by using index property but what are the other ways we have have to solve this problem. Login (href: btnlogin.aspx) Login (href: Sourcelogin.aspx) Login (href: homelogin.aspx)
when to start the automation?
Mention the different actions types of qtp.