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

What is file database?

0 Answers   Syntel,


How to Parameterize Object repository in QTP?

1 Answers  


What is quicktest professional (qtp)?

0 Answers  


How we can call the scripit from another scripit in QTP?,Not a call Action

12 Answers  


What is the keyword view and expert view in qtp?

0 Answers  


Wt is the difference between Business Component and scripted component?

1 Answers   BSL,


What type of VB script u had done in expert view?

1 Answers  


Q) Please any body can help me how we can create descriptive programming if the application is not ready i.e we don't have unique property of object ? note:build not ready means we can't use object spy in build to get unique property .

2 Answers  


hi, i was adding the two numbers in qtp scripts but i didn't get the answer. see my below script, i dont know wht is the problem. i passed the value a=3 b= 2, i got the ans 32 instead of 5. i thing the problem is to be c = a+b my mail id karthis4u@gmail.com Dim a, b, c a = inputbox("enter the a ") b = inputbox("enter the b ") c = a + b print c

8 Answers  


i need code for how to click on particular mail in utlook mail box .its urjent Thank You Balaji

0 Answers  


how to identify the objects if application consists of objects that have same properties.

4 Answers  


I am Facing Issues with learing datepicker 1)when i first learn datepicker as current system date . 2)if i wanna runtime datepicker value it gives error

0 Answers  


Categories