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



There r 1000 rows and 1000 coloums , in that I want pickup a name of the coloumn , pls dont say in..

Answer / 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

More QTP Interview Questions

What is the XML file architecture ?

1 Answers  


What is difference between design time and run time data table?

1 Answers  


How do I get the QTP scripts result in xml format by using vb script function?

1 Answers  


In qtp, how you can get the last character from a string?

1 Answers  


Is there anyway to have QTP go into a website and map out every object before I actually record any tests? I basically want to map out a website with all the objects and build a complete repository. The reason is because I'm running into issues with hierarcical objects. for example: Browser("ABC company- Home").Page("ABC company - Home").Link ("About Us").Click Browser("ABC company - Page 2").Page("ABC company - Page 2").Link("About Us").Click Both these links ("objects" and I use that term loosely as I'm trained mostly in OO programming) go to the same place but but the object heirarchies (pages) are different. I want a repository that will find any possible link on any possible page without having to manually record it. Is there a way to do this?

1 Answers  


What does VBS file contain..? what is VBS file.?

4 Answers  


How will you send values to a cell in a webtable using QTP?

2 Answers  


Does QTP run in any environment?

1 Answers  


Give me brief idea about QTP automation object model?

5 Answers   TCS,


what difference between client and server applications exatly?

1 Answers   Honeywell,


What is the differnce between action & script

1 Answers  


suppose u hav a dialog or window which contains 10 buttons with same name & value. now how to check each button? i.e. how qtp indetifies these objects separately?

2 Answers  


Categories