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

With out using the task manager,how to close the application using vbscript and what is the statement?

1 Answers  


Object recognition in QTP is based on which model ? a) COM b) DCOM c) DOM d) None of the above

2 Answers   Ordain Solutions,


Suppose I created one object as virtual object? That object is applicable to that test? Or all the tests?

0 Answers  


anyone can explain Diff B/w Actions and Functions

2 Answers  


What is difference between the For..Next and While..Wend statements?

2 Answers  


Hi all, I am using windows vista, I am in the process of learning QTP. When ever I try to work with insert mode in flight application , i am getting the error of 'Operation must use an update table query, fractional truncation(null) error. Can anyone help me regarding this?

0 Answers  


I want to read XML file loaded in Quality center and compare the values with the values displayed in Application (web table).How can I do that

0 Answers  


What is the extension of script and object repositary files?

7 Answers   Maveric,


How to pass parameters into an action.Please explain me with examples

5 Answers  


Deal All, Recently i face one interview question in one company. str="test12@#3456" In This i want to print like special character and numeric ,word in one script please tell me how to write the code for this Thanks Balaji

1 Answers  


What are the Mandatory Properties of WebTable Object and Link Object in Web testing using QTP

2 Answers   iLink,


in my database haveing 3X3 (manas having 3 rows 3 colums) i want to test only (2nd row 3colum) bit how to test either script or any automation plz explain? (Chandana)

8 Answers   IBM,


Categories