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
- 1 Answers
- 3864 Views
- I also Faced
- E-Mail Answers
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
Define Environment Variable in UFT and its uses?
I am a newbie to QTP / Automation testing. I want to develop a script that creates a data file automatically with proper headings using VBScript in QTP.
How software automation specialist enter steps in the Expert View?
How to export quicktest professional results to an .xls file?
How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s.
Is it possible to use two instances of UFT on the same machine? If not why?
How are cgi programs, applets, javascripts, ActiveX components, etc. to be maintained, tracked, controlled, and tested?
1.How do u prepare the test suits in QC? 2.How do u convert requirements to test plan in QC?
I want to open a Notepad window without recording a test and I do not want to use System utility Run command as well. How do I do this?
How do you handle multiple banners(at the top the page, the banner is scrolling) in a web page(Dont take the name property(regular expression))
How many types of recording modes in the qtp?
how did u use automating testing tools in ur job?
How can you close the second opened browser?
What do you mean by checkpoints in qtp?
How to create a standard checkpoint ?
