syntex of insert

Categories >> Software >> Databases >> SQL Server
Suggest New Category

syntex of insert

Question Posted / guest

7 Answers
7549 Views
I also Faced
E-Mail Answers

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