Answers were Sorted based on User's Feedback
Answer / srinivas reddy
In SQL Insert statement is
insert into tablename values(columnname1 datatype,
|Is This Answer Correct ?||3 Yes||1 No|
Answer / pravati
INSERT INTO tablename(column name1,column name2,column name3....)
|Is This Answer Correct ?||1 Yes||0 No|
Answer / vamsilakshman
create table tablename (sid int,sname varchar(20))
insert into tablename(1,'vamsi')
insert into tablename(2,'lakshman')
|Is This Answer Correct ?||0 Yes||0 No|
Answer / ghanshyam vrema
USING ADO Command Object
|Is This Answer Correct ?||1 Yes||5 No|
How to use Text file (Notepad) as ur data source in QTP? Can u please provide some function code for it?
hi all, i had a question, that how to find out hiding a coloumn in a table i had a table having the following column names NAME DESCRIPTION CREATED TIME CREATED USER if i right clicked on a NAME column it will displays a menu having the same column names in a list like NAME DESCRIPTION CREATED TIME CREATED USER with check boxes.if i unched any check box, that column name should not be appear in the main table column names could anyone please solve this problem?
Write a program to resize an array of 5 elements to 4 elements and display all the elements.
how to display all the links in one page using vb script in qtp.
Plz give the vb script for the following scenerio. In travel booking we have to select from delhi to mumbai from the combobox The prices will be display in another combo box .But i have to select the lowest price for it and submit it
Here in my automation tool, i am retreiving some values and i need to store this values in the excel. How can i achieve this?. We are using VBA as scripting language. please let me know if you require any further inputs.
1.I want to establish connection with excel and also want to fetch the data using SQL queries. 2.the code should be written in such a way that in future if I want to migrate from excel to MS excess database , then there should be minimal changes.
write a program to display configuration of a local system with the help of vb script.
Set srchobj=Description.Create() srchobj("type").value="text" srchobj("name").value="q" srchobj("html tag").value="input" browser("micclass:=google").Page("micclass:=google").webedit (srchobj).Set "qtp" what's wrong in my code pls tell me ? the above code working fine and i got my result pass,now i am trying to run the program it shows general run time error why?pls help me i am in learning stage ?
write a vb script to display factorial of a number using function
Find Out Length of an array without using Ubound?
best training centre in bangalore