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....)
VALUES(value1,value2,value3...)

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 increasing the numbers in a given text box please write a vb script

0 Answers  


I need to get some data from data base and store this (retrieved) data in a excel sheet using VB script in QTP9.0 I have created connection for data base I have created as excels sheet by using Set XL=CreateObject("Excel.Application") XLworksheet.cells(1,1).value= rs.fields.item("<<The data retrieved from data base >>") I have taken a for loop and changed the cells values (1 as i and another 1 as j) But still I am not able to get Plz kindly tell me know this . It is very urgent

0 Answers  


write a vb script to display 3*3 matrix

1 Answers  


write a vb script to display the reverse of vbs

2 Answers  


In html file what is an ideal position to include vbscript?

0 Answers  


accept a string & display whether a is present or not

1 Answers  


what is the differenece btwn scripting language and programming language

4 Answers  


how to find the textfile in the folder and copy file from one folder to another folder useing parameterigation in QTP

1 Answers   Accenture,


what is descriptive programming in QTP and what is environment variable in QTP? where we store and what is its use?

4 Answers   Perot Systems,


What is the use of the date function in the vbscript language?

0 Answers  


How are values assigned to the variables in the vbscript language?

0 Answers  


please can you help me to get a code of flames using a visual basic 6

0 Answers  


Categories