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 the keyword view and expert view in qtp?
How did you use regular expressions in QTP and also in WR?
How will you check a web application for broken links using qtp?
Should have experience in framework means?
What are the advantages of parameterization ?
Why we load add-ins in qtp?
What is the qtp testing process?
What are the general steps involved in the data driven framework?
How will you test a stapler?
How can I check if a environment variable exist or not?
I would like to directly import XL file and work on that XL file directly in QTp script in that XL sheet need to allocate workbench,XL sheet and generate two bar graphs automatically how to do that? plz let me know any answers?
Explain object spy in qtp.
What is a quick test professional?
What is the script for database check point, bitmapchek point, regular expression ?
How to check bitmap output value?