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
Dear All, How to generate Pass or Fail Report in QTP without using Reporter.Report Event Method ? Thanks Balaji
What are the different recording modes?
Which advantages helping QTP to hold the position of "Market Leader" for such a long period?
Can anyone pls tell me how to do action parameterization (input and output parameters) with respect to login window and insert order of flight reservation window in detail( pls give a clear step by step explanation with example) anyone please. Will be very thankful to u
How does qtp identify the object in the application?
I have many listboxes in my application. I have to check whether the contents inside the listboxes are in sorted order or not..can anyone please send the code as early as possible
How many tabs are available in debug viewer pane?
Where we can use the analog mode and where we can use the low – level mode?
How do you open adobe acrobat file in QTP and do some testing on that file ?
What are the ordinal identifiers in web page?
Hybrid framework supports Descriptive programming. Is it true?
When to use descriptive programming?
how will you load the test cases in ddt?
How to use the object spy in quicktest professional (qtp) 8.0 version?
Hi all Can u give me the link where we can download full version of qtp my mail id is karthic.venkitapathi@gmail.com