Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

I register user defined function in one test, I tried to call that function into other test. But that function not works in other test please give the direction for that.

1 Answers  


Diff between WEB APPLICATION AND CLIENT-SERVER APPLICATION?

2 Answers  


Tell me the situations where we will use Data Driven?

2 Answers  


QTP -object reposistory spy tool is not able to spy the pop up message appearing in the application, so how is that i can handle such run time pop ups in QTP by code???

2 Answers   CGI,


Difference between object identification and smart identification

2 Answers   Wipro,


Difference between image checkpoint and bitmap checkpoint

4 Answers  


How to capture screen shots when an error occurs?

5 Answers   EDS,


request to add whatsapp grp for test engineer

1 Answers  


How to identify flash application when the qtp is not identifying the flash application objects.

2 Answers  


hi Action 1 and action2 if we save it in C:, what folders will be created explain plz

3 Answers   iFlex,


How to add a runtime parameter to a data sheet?

6 Answers  


How to find if given number is prime or not

1 Answers  


Categories