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 syntax for encrypting a column in SQL Server?
What is onf in normalization form?
How to create a new schema in a database?
What are the differences between local and global temporary tables?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
List the different types of collation sensitivities in sql server?
What is oltp (online transaction processing)?
what is bit datatype? : Sql server database administration
Explain about extended stored procedure?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18
How can I change procedure name in sql server?