How do you write an SQL insert statement?

Answers were Sorted based on User's Feedback

How do you write an SQL insert statement?..

Answer / srinivas reddy

In SQL Insert statement is

insert into tablename values(columnname1 datatype,
columnname2 datatype........)

Is This Answer Correct ?    3 Yes 1 No

How do you write an SQL insert statement?..

Answer / pravati

INSERT INTO tablename(column name1,column name2,column name3....)

Is This Answer Correct ?    1 Yes 0 No

How do you write an SQL insert statement?..

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

How do you write an SQL insert statement?..

Answer / ghanshyam vrema

USING ADO Command Object

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More VB Script Interview Questions

How to use Text file (Notepad) as ur data source in QTP? Can u please provide some function code for it?

1 Answers  

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?

0 Answers   Livetek,

Write a program to resize an array of 5 elements to 4 elements and display all the elements.

1 Answers  

how to display all the links in one page using vb script in qtp.

1 Answers   DST Global Solutions,

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

1 Answers   IBM,

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 Answers  

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.

0 Answers  

write a program to display configuration of a local system with the help of vb script.

0 Answers  

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 ?

0 Answers  

write a vb script to display factorial of a number using function

1 Answers  

Find Out Length of an array without using Ubound?

1 Answers  

best training centre in bangalore

2 Answers