syntex of insert

Answers were Sorted based on User's Feedback



syntex of insert..

Answer / mahathi

insert into tablename (col1,col2,........) values
(val1,val2,........)

Is This Answer Correct ?    9 Yes 1 No

syntex of insert..

Answer / dk

Insert into tablename (c1,c1,c3,...) values(v1,v2,v3,...)

and we can also use
Insert into tablename values(v1,v2,v3,...)
but in this we must have to know numbers of columns and we
have to insert values for all not null columns

Is This Answer Correct ?    2 Yes 1 No

syntex of insert..

Answer / d

insert into (table name) values(fieldname datatype);


for ex:

insert into emp values(eno number(3),ename varchar2(20));

Is This Answer Correct ?    0 Yes 0 No

syntex of insert..

Answer / jasmeet kaur

insert into table_name("column_name1","column_name2")
value("value1","value2")

Is This Answer Correct ?    0 Yes 0 No

syntex of insert..

Answer / gajanan.waghode

INSERT INTO table[(cloumn [,cloumn...])]
VALUES (value[,value...]);

with this syntax only one row is inserted at a time.

Is This Answer Correct ?    0 Yes 0 No

syntex of insert..

Answer / s

insert table <tablename>(col1,col2,.)values(..)

Is This Answer Correct ?    0 Yes 2 No

syntex of insert..

Answer / vanitha

insert into table tablename((field name datatype()))

Ex:
{
insert into table emp((eno int, ename varchar(10),eid int))
}

Is This Answer Correct ?    1 Yes 8 No

Post New Answer

More SQL Server Interview Questions

What is the most common type of join?

0 Answers  


Tell me what is de-normalization and what are some of the examples of it?

0 Answers  


how to know Who Is Blocking Your SQL Server?

4 Answers  


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  


How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...

1 Answers   Cognizant,






What is the command used to check locks in microsoft sql server?

0 Answers  


What is meant by indexing files?

0 Answers  


Does a sql server 2005 select statement require a from?

0 Answers  


What are the main control-of-flow T-SQL constructs?

1 Answers  


How do you persist objects, permissions in tempdb

1 Answers  


What is pivot and unpivot?

0 Answers  


What is optimization and its types?

0 Answers  


Categories