syntex of insert
Answers were Sorted based on User's Feedback
Answer / mahathi
insert into tablename (col1,col2,........) values
(val1,val2,........)
Is This Answer Correct ? | 9 Yes | 1 No |
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 |
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 |
Answer / jasmeet kaur
insert into table_name("column_name1","column_name2")
value("value1","value2")
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
What is the most common type of join?
Tell me what is de-normalization and what are some of the examples of it?
how to know Who Is Blocking Your SQL Server?
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?
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...
What is the command used to check locks in microsoft sql server?
What is meant by indexing files?
Does a sql server 2005 select statement require a from?
What are the main control-of-flow T-SQL constructs?
How do you persist objects, permissions in tempdb
What is pivot and unpivot?
What is optimization and its types?