How do you write an SQL insert statement?

Question Posted / panigrahi_saroj30

4 Answers
8111 Views
HCL, I also Faced
E-Mail Answers

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

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

1 Answers

What is the difference between a dictionary and an array?

0 Answers

How can you test font size, type and color using QTP tool?

3 Answers

Hi everybady, i have faced few Qns in one of i attended interview, please help me out with these below Qns. 1. how to join values without using join function? 2. how to compare values without using String compare function? 3. input is Bangalore, but i need output like this below format, what is function to use and get this outcome B A N G A L o R E 4. Input is "CapGemini" but uotput should be like this "inimeGpaC" 5. Input is 1 1 2 1 2 3 1 2 3 4 1 2 3 4 5 Can someone let me know results of this Qns, please. Thanks.

2 Answers CSS Corp,

when we use filter funtiom invb script(QTP)

0 Answers TCS,

Dear All, I am geting below IE error whilie executing the QTP scripts in Batch mode "Internet Explorer has encountered a problem and needs to close. We are sorry for the inconvenience." can any one suggest me how to resolve this issue . Thanks Balaji

0 Answers

Mention the environments where vbscript could be run?

0 Answers

Mention the rules for using option explicit statement?

0 Answers

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

0 Answers

How will you convert a given number to long in vbscript?

0 Answers

Which in-built functions are used to convert the specified expression in the form of date and string in the vbscript language?

0 Answers

1. How do declare public variable in vb scripts?

0 Answers

For more VB Script Interview Questions Click Here