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
Is there anyway to automatically update the Datasource name in Database Checkpoints object when we migrate tests to a new release?
how will you check how many members visited the website www.infosys.com?
Can QTP be used for GUI testing ?, We are using Java with MySQL and Operating system is Linux. We are NOT using the web.
How can I check if a environment variable exist or not?
Explain more about the Test Fusion Report of QTP?
Suppose you are using shared objects repository in your test and you want to split your present action? At that time shared object repository is single or it’s also splits?
How many types of parameters are available in quicktest professional?
What is the parameterization? Give one example?
What are the types of environment variables in qtp?
In an interview, what r the general questions asked in QTP? pls give me anwser to this question?
What is qtpro? What is quick test pro?
What are the different types of qtp test assets and their extensions?
Did the scripts need lot of maintenance? If yes, why?
What phases are involved in testing an application in qtp?
What is keyword view?